=len(d16) if no spaces


=LEN(SUBSTITUTE(D16," ",""))
--
Don Guillett
SalesAid Software

"carl" wrote in message
...
is there a way to count the charaters in a cell. For example, my
spreadsheet
looks as so:

AA
DDD
SSSSS

Can a formula in col B show the following:

2
3
5

Thank you in advance.