Counting characters

S

sdmccabe

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

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.
 
L

L. Howard Kittle

=Len(A1) will give you the characters and spaces if any.
=LEN(SUBSTITUTE(A1," ","")) will give you just the characters.

HTH
Regards,
Howard
 
Top