Character Count

H

Hardip

Hi All

I am trying to count the number of characters in a cell i.e. all numbers,
letters and smybols.

Is there are worksheet function that can assist me?

Thanks in advance to all whom reply.

Regards, H
 
P

Peo Sjoblom

=LEN(A1)

will count spaces as well so if you want to disregard those use

=LEN(SUBSTITUTE(A1," ",""))
 
R

Ron Coderre

Try this:
For a value in Cell A1
B1: =LEN(A1)
returns the number of characters in cell A1

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
B

Bob Phillips

=LEN(A1)

If you want to ignore space, use

=LEN(SUBSTITUTE(A1," ",""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
H

Hardip

Hey Rod,

Thanks for the response - managed to figure it out eventually.

Have a good day - H
 
H

Hardip

Thanks for the response :)

Peo Sjoblom said:
=LEN(A1)

will count spaces as well so if you want to disregard those use

=LEN(SUBSTITUTE(A1," ",""))


--

Regards,

Peo Sjoblom
Click to expand...
 
Top