Counting Characters In A Cell


Posted by Sean B on January 02, 2002 6:33 AM

How can I create a fuction that says if there are less than x characters in cell then cell = whatever



Posted by Scott on January 02, 2002 6:38 AM

The function is "=LEN(A1)

This will return a the number of characters in the cell. Be aware that it will also return a number for spaces between words.