Formula to determine number of times a character exists in a cell: "_" in cell = abc_def_ghi_xyz

[ThePazMan]

Formula to determine number of times a character exists in a cell:  I want to find the number of times "_" exists in cell = abc_def_ghi_xyz

[#2 · Accepted solution]

@ThePazMan 

Let's say the cell is A1. The number of "_" in the cell value is:

=LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))

[#3]

TY - works great