Forum Discussion
nprager1450
Mar 05, 2025Copper Contributor
count how many dashes in a cell
Hi, I hope you can help me create a formula that counts how many dashes are in a cell. For example, I might have a cell with "000-111-333-11" and a cell with "000-111-333." I am hoping there is a for...
Harun24HR
Mar 06, 2025Bronze Contributor
You may try LEN() and SUBSTITUTE() functions.
=LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))