View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default VBA - Counting Characters in Cell

For example:

Len(Range("A1"))

--

Vasant



"ajocius" wrote in
message ...

Group,
How can I count the number of characters that appear in a cell?
The characters are in text. The only characters appearing are 0-9, A,
B, C, D, E, F and $. I need to know how many characters appear in a
cell give a Row, Column. Actually it doesn't matter what characters
reside in the cell, the number of characters is the important thing I'm
looking for.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=395220