Character Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=LEN(A1)

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

=LEN(SUBSTITUTE(A1," ",""))
 
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
 
=LEN(A1)

If you want to ignore space, use

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Hey Rod,

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

Have a good day - H
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some help with a COUNTIF function 4
Counting assistance 3
Formula/Function for Counting Characters in a cell 4
Adding the total # of characters in multiple cells 3
Counting the number of times a character occurs in a cell 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Finding/counting a given character within a cell 10
COUNTA Function 6

Back
Top