Counting the # of Characters in a Cell
Posted by Beth on November 09, 2001 12:11 PM
Is there a way to count the # of characters in a cell? For instance, if you have a cell with the word "car" the result would be 3 ???
Posted by Denis on November 09, 2001 12:18 PM
the formula =len(a1) will count the nuber of characters in cell a1
Posted by Tom Urtis on November 09, 2001 12:19 PM
Probably the LEN function would do what you want. If Car is in A1, then in B1 you can enter
=LEN(A1), which returns a value of 3.
Is this what you want?
Tom U.
Posted by Rick E on November 09, 2001 12:22 PM
Use the Len() function. Example if in cell A3 the word car is in it, put =Len(A3) in cell B3 and there will be the value 3 in B3.
Change A3 to something else and the character count of it will be in B3
Posted by beth on November 09, 2001 12:45 PM
THANK YOU!!! It works!!!
