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?