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?
 
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
 

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
Individual Character fonts in a cell 12
Map characters to their relative positions in a cell 3

Back
Top