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?

How about using the Len function?

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

--
Rick (MVP - Excel)


"Martin" wrote in message
...
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?

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

"Rick Rothstein" wrote:

How about using the Len function?

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

--
Rick (MVP - Excel)


"Martin" wrote in message
...
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?

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
--------------
Jacob Skaria


"Martin" wrote:

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?