+ Reply to Thread
Results 1 to 6 of 6

Character Count

  1. #1
    Hardip
    Guest

    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

  2. #2
    Peo Sjoblom
    Guest

    Re: Character Count

    =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




  3. #3
    Ron Coderre
    Guest

    RE: 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


  4. #4
    Bob Phillips
    Guest

    Re: 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" <[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




  5. #5
    Hardip
    Guest

    RE: 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


  6. #6
    Hardip
    Guest

    Re: 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" <[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

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1