Number of Characters in a Cell

[Martin]

I want to count the number of Characters in a cell. I had thought of using a
Do While loop and the Mid() Function to count, but I don't know what the last
character is?

Anybody got any ideas?

 

[Rick Rothstein]

How about using the Len function?

NumberOfCharacters = Len(Range("A1").Value)

 

[Martin]

Oh dear, of course that would be the way to go, completely forgot that
function!!!

 

[Jacob Skaria]

Dear Martin

TRIM the value if imported from an external source and use the LEN function
as below.

LEN(Trim(Range("A" & intRow)))

If this post helps click Yes