Is There Excel Function to Count a Certain Character in Value 2

[alex20850]

I have a list of codes. Some of these codes have one dash in them, others two, some with one space, some with two or more. I would like to run a function that would count how many dashes (or how many spaces) are in a code.

 

[SkipVought]

Hi,

Please post VBA code questions in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

If you wanted a formula to tell you how many dashes were in a code then:
=LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))
would do it.
Likewise, to see how many spaces were in a code, then:
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))
would do it.
To count how many spaces or dashes were in a code:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"-","")))+(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))

Cheers, Glenn.

Beauty is in the eye of the beerholder.