How to Count Character In a Cell 1

[JoaoLima]

Hi All,
I Would like to know how to count the number of character in a selected cell.
Thanks in advance,

João Lima

 

[PCX]

I assume you mean in Excel?

If so, this is not really a VBA way to do it but the easiest way is to use the command =LEN(A1). If you put this in any cell except A1 it will return the length of the contents of cell A1.

Is that what you meant?

 

[acron]

If you need to do it in VBA, you can use one of the following, with A1 as the example :

= Len([A1]) , or

= Len(Range("A1&quot)

AC

 

[ide]

..
=Len(ActiveCell) ide

 

[asjeff]

or how about: myCount = Activecell.Characters.Count?

Asjeff