SOLVED

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

Copper Contributor

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

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 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

# Re: Formula to determine number of times a character exists in a cell: "_" in cell = abc_d

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

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

# Re: Formula to determine number of times a character exists in a cell: "_" in cell = abc_d

TY - works great
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

# Re: Formula to determine number of times a character exists in a cell: "_" in cell = abc_d

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

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