Can you calculate no. CHARACTERS

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!

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?
>

=LEN(A1)

gives the number of characters in cell A1.

Regards,

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

if you have "helpme" in A1, =LEN(A1) in B1 will return 6

"Lynz" wrote:

> 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!