Count the number of characters created by string text

Discussion in 'Microsoft Excel Discussion' started by mrlanier@hotmail.com, Jan 19, 2007.

  1. Guest

    Is there a formula that will count the number of characters, and spaces
    between characters, in a short paragraph created by a string text? It
    is acceptible if spaces cannot be counted. Thanks.

    Michael
     
    , Jan 19, 2007
    #1
    1. Advertisements

  2. JE McGimpsey Guest

    Answered in another group you posted to.

    In article <>,
    wrote:

    > Is there a formula that will count the number of characters, and spaces
    > between characters, in a short paragraph created by a string text? It
    > is acceptible if spaces cannot be counted. Thanks.
    >
    > Michael
     
    JE McGimpsey, Jan 19, 2007
    #2
    1. Advertisements

  3. Guest

    Thanks.

    Michael
     
    , Jan 19, 2007
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Alex Burman

    Count specific character in text string

    Alex Burman, Mar 30, 2004, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    7,209
    Alex Burman
    Mar 30, 2004
  2. Toby Erkson

    Display count of characters in a cell while typing.

    Toby Erkson, Sep 1, 2004, in forum: Microsoft Excel Discussion
    Replies:
    7
    Views:
    2,308
    Earl Kiosterud
    Sep 3, 2004
  3. Angela

    Re: "SUMIF" or "COUNTIF" to count alpha characters as .5 ?

    Angela, Sep 18, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    1,232
    Debra Dalgleish
    Sep 18, 2004
  4. Jacob

    Count number of lines of text in a range/value.

    Jacob, Oct 18, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    208
    Jacob
    Oct 18, 2005
  5. TxWebdesigner

    Count characters

    TxWebdesigner, Jul 18, 2007, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    140
    Rick Rothstein \(MVP - VB\)
    Jul 18, 2007
  6. skiing

    strip characters from a "number" like string

    skiing, May 6, 2008, in forum: Microsoft Excel Discussion
    Replies:
    27
    Views:
    492
    ACarella
    Jul 11, 2008
  7. Jen

    Help with double text string search count

    Jen, May 3, 2011, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    295
  8. Andy Roberts

    Remove certain characters from a text string

    Andy Roberts, Jun 15, 2013, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    370
    Claus Busch
    Jun 15, 2013
Loading...