+ Reply to Thread
Results 1 to 3 of 3

can you count the number of letters (inc spaces) in a single sell

  1. #1
    greenstone
    Guest

    can you count the number of letters (inc spaces) in a single sell

    I have a spreedsheet which has 3000 rows. Each cell has a different amount
    of words in it... ie ABC Learning Centre Ferrymead.

    Is it possible to count the number of characters (letters) including spaces
    in each cell??? (please note each cell has a different number of letters in
    it)... or do I have to do this manually? none of the help options seem to
    help me...

    Thanks

  2. #2
    Registered User
    Join Date
    08-01-2005
    Posts
    3
    use the formula =len()

  3. #3
    Gordon
    Guest

    Re: can you count the number of letters (inc spaces) in a single sell

    "greenstone" <[email protected]> wrote in message
    news:[email protected]
    > I have a spreedsheet which has 3000 rows. Each cell has a different
    > amount of words in it... ie ABC Learning Centre Ferrymead.
    >
    > Is it possible to count the number of characters (letters) including
    > spaces in each cell??? (please note each cell has a different number
    > of letters in it)... or do I have to do this manually? none of the
    > help options seem to help me...
    >
    > Thanks


    Just out of pure curiosity, can I ask why you need to do this?



+ 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