Recognizing the Length of a Text Value

  • Thread starter Thread starter Ken H.
  • Start date Start date
K

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
 
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
 
Van P. said:
To be a bit safer and to eliminate any spaces that the "LEN" formula
would count try:

=LEN(TRIM(LEFT(A1,LEN(A1))))
Click to expand...
....

Why not just

=LEN(TRIM(A1))

?
 
Back
Top