MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!!!