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
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," ",""))
--
Regards,
Peo Sjoblom
"Hardip" <[email protected]> wrote in message
news:[email protected]...
> 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
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
=LEN(A1)
If you want to ignore space, use
=LEN(SUBSTITUTE(A1," ",""))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Hardip" <[email protected]> wrote in message
news:[email protected]...
> 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
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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks