Forum Discussion
Solved
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
Let's say the cell is A1. The number of "_" in the cell value is:
=LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))
Let's say the cell is A1. The number of "_" in the cell value is:
=LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))
TY - works great