Can I find the number of letters in a cell?
Or, in the slim chance that your example will always be commas as indicated
and no spaces...
=LEN(SUBSTITUTE(A1,",",""))
HTH
Regards,
Howard
"dave_laroche" wrote in message
...
I am trying to find a method of calculating the number of letters in a
particular cell... I can calculate the number of cells that have letter
entries, but I cannot find how to calculate the number of letters in a
cell.
For example:
Cell B12: b,c,d
Cell B12: I would like to be able to develop a formula to get the number
'3'
|