Recognizing the Length of a Text Value

[Ken H.]

How can I have Excel figure out how many characters are
in a text sequence located in an individual cell?
For example, if the value of cell A1 is "ABC" I want cell
B1 to return a value of "3". If cell A2 is "ZZ" I want
cell B2 to return a value of "2". If cell A3 is "UVWXYZ"
I want B3 to equal "6". Thanks - Ken

 

[Aladin Akyurek]

=LEN(A1)

 

[Robert Nguyen]

If A1 value is "ABC" then
=LEN(A1)
would return 3

 

[Scott]

=LEN(A1) should do the trick.

Cheers!

 

[Guest]

To be a bit safer and to eliminate any spaces that the "LEN" formula would count try

=LEN(TRIM(LEFT(A1,LEN(A1)))

Va


----- Scott wrote: ----

=LEN(A1) should do the trick

Cheers

 

[Harlan Grove]

To be a bit safer and to eliminate any spaces that the "LEN" formula
would count try:

=LEN(TRIM(LEFT(A1,LEN(A1))))

....

Why not just

=LEN(TRIM(A1))

?