auto count for cells
 

Is there any way to count the characters in a cell?
I have to only have 12 in one and 30 in another.
HELP!!
christa

The formula is
=LEN(A1)
Substitute your actual cell reference for A1. This returns the number
of characters in a string.

YES!!!! THANK YOU SO MUCH. You just saved me literally hours of work.

"Dave O" wrote:

The formula is
=LEN(A1)
Substitute your actual cell reference for A1. This returns the number
of characters in a string.

Thanks from me to! So simple and yet saves so much time!
Cheers
Jim

"Dave O" wrote:

The formula is
=LEN(A1)
Substitute your actual cell reference for A1. This returns the number
of characters in a string.