G Guest Mar 27, 2006 #1 Could you suggest a formula to count the total number of alpha-numeric characters in an adjoining cell?
Could you suggest a formula to count the total number of alpha-numeric characters in an adjoining cell?
Z Zack Barresse Mar 27, 2006 #2 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.
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 Mar 27, 2006 #4 =Len(A1) will give you the characters and spaces if any. =LEN(SUBSTITUTE(A1," ","")) will give you just the characters. HTH Regards, Howard
=Len(A1) will give you the characters and spaces if any. =LEN(SUBSTITUTE(A1," ","")) will give you just the characters. HTH Regards, Howard
