Number of Charachters in a cell
 

Hi guys!!!

Easy one - how do you count the numbers of charachters with a cell?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

Number of Charachters in a cell
 

Hi Darin,
Easy one - how do you count the numbers of charachters with a cell?

=len(a1)

arno

Number of Charachters in a cell
 

use LEN()
e.g. LEN(A1)

- Mangesh



"Darin Kramer" wrote in message
...


Hi guys!!!

Easy one - how do you count the numbers of charachters with a cell?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

Number of Charachters in a cell
 

Anyone know why LEN and LENB return the same number on my English
W2K/Office2000 with Chinese text (i.e. both return the number of characters)
but return the correct numbers (i.e.characters & bytes repectively) on my
Chinese W2K/Office2000 with Chinese text.

NickHK

"arno" wrote in message
...
Hi Darin,
Easy one - how do you count the numbers of charachters with a cell?

=len(a1)

arno