Can you calculate no. CHARACTERS

L

Lynz

I know that it is possible to calculate the number of words within an excel
cell but is it possible to calculate the number of characters?

I hope someone can save me from staring at a screen with a pointer!
 
J

Jan Karel Pieterse

Hi Lynz,
I know that it is possible to calculate the number of words within an excel
cell but is it possible to calculate the number of characters?
Click to expand...

=LEN(A1)

gives the number of characters in cell A1.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
Top