software

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,quot; quot;,quot;quot;))--

Regards,

Peo Sjoblom

quot;Hardipquot; gt; wrote in message
news
gt; Hi All
gt;
gt; I am trying to count the number of characters in a cell i.e. all numbers,
gt; letters and smybols.
gt;
gt; Is there are worksheet function that can assist me?
gt;
gt; Thanks in advance to all whom reply.
gt;
gt; Regards, H
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-Proquot;Hardipquot; wrote:

gt; Hi All
gt;
gt; I am trying to count the number of characters in a cell i.e. all numbers,
gt; letters and smybols.
gt;
gt; Is there are worksheet function that can assist me?
gt;
gt; Thanks in advance to all whom reply.
gt;
gt; Regards, H

=LEN(A1)

If you want to ignore space, use

=LEN(SUBSTITUTE(A1,quot; quot;,quot;quot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Hardipquot; gt; wrote in message
news
gt; Hi All
gt;
gt; I am trying to count the number of characters in a cell i.e. all numbers,
gt; letters and smybols.
gt;
gt; Is there are worksheet function that can assist me?
gt;
gt; Thanks in advance to all whom reply.
gt;
gt; Regards, H
Hey Rod,

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

Have a good day - H

quot;Ron Coderrequot; wrote:

gt; Try this:
gt; For a value in Cell A1
gt; B1: =LEN(A1)
gt; returns the number of characters in cell A1
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Hardipquot; wrote:
gt;
gt; gt; Hi All
gt; gt;
gt; gt; I am trying to count the number of characters in a cell i.e. all numbers,
gt; gt; letters and smybols.
gt; gt;
gt; gt; Is there are worksheet function that can assist me?
gt; gt;
gt; gt; Thanks in advance to all whom reply.
gt; gt;
gt; gt; Regards, H

Thanks for the response :-)

quot;Peo Sjoblomquot; wrote:

gt; =LEN(A1)
gt;
gt; will count spaces as well so if you want to disregard those use
gt;
gt; =LEN(SUBSTITUTE(A1,quot; quot;,quot;quot;))
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Hardipquot; gt; wrote in message
gt; news
gt; gt; Hi All
gt; gt;
gt; gt; I am trying to count the number of characters in a cell i.e. all numbers,
gt; gt; letters and smybols.
gt; gt;
gt; gt; Is there are worksheet function that can assist me?
gt; gt;
gt; gt; Thanks in advance to all whom reply.
gt; gt;
gt; gt; Regards, H
gt;
gt;
gt;