View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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'