Counting characters

[sdmccabe]

Could you suggest a formula to count the total number of alpha-numeric
characters in an adjoining cell?

[Zack Barresse]

Hello there,

To count all characters in a cell, check out the LEN formula. To count
specifics, either all numbers or all alpha-characters, it becomes more
tricky.

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"sdmccabe" <sdmccabe@discussions.microsoft.com> wrote in message
news:6A26499B-6D28-48F2-9434-7E736C86FD3A@microsoft.com...
> Could you suggest a formula to count the total number of alpha-numeric
> characters in an adjoining cell?

[Biff]

=LEN(A1)

Biff

"sdmccabe" <sdmccabe@discussions.microsoft.com> wrote in message
news:6A26499B-6D28-48F2-9434-7E736C86FD3A@microsoft.com...
> Could you suggest a formula to count the total number of alpha-numeric
> characters in an adjoining cell?