Number of Characters in a Cell

  • Thread starter Thread starter Martin
  • Start date Start date
M

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?
 
How about using the Len function?

NumberOfCharacters = Len(Range("A1").Value)
 
Oh dear, of course that would be the way to go, completely forgot that
function!!!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No characters data in Hyperlink cell 3
counting characters in a cell 3
Count latest number of continous not-empty cells in a row. 11
Test if Last Character in Column of Cells is Alpha Character 6
Column Cell character number checking 4
MACRO BASED ON A NUMBER OF CHARACTERS 2
Map characters to their relative positions in a cell 3
Individual Character fonts in a cell 12

Back
Top