Character Count
 

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

Character Count
 

=LEN(A1)

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

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


--

Regards,

Peo Sjoblom

"Hardip" wrote in message
...
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

Character Count
 

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


"Hardip" wrote:

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

Character Count
 

=LEN(A1)

If you want to ignore space, use

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Hardip" wrote in message
...
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

Character Count
 

Hey Rod,

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

Have a good day - H

"Ron Coderre" wrote:

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


"Hardip" wrote:

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

Character Count
 

Thanks for the response :-)

"Peo Sjoblom" wrote:

=LEN(A1)

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

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


--

Regards,

Peo Sjoblom

"Hardip" wrote in message
...
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