How can I count the number of characters in a cell?? Assume no spaces
J JulieD Nov 12, 2004 #2 Hi the LEN function will give you the length of the string, ie the number of characters e.g. =LEN(A1) Cheers JulieD
Hi the LEN function will give you the length of the string, ie the number of characters e.g. =LEN(A1) Cheers JulieD
F Frank Kabel Nov 12, 2004 #3 Hi =LEN(A!) or if you want to ignore spaces try: =LEN(SUBSTITUTE(A1," ",""))
