Results 1 to 7 of 7

Thread: How to count number of characters in Excel

  1. #1
    Join Date
    Feb 2009
    Posts
    34

    How to count number of characters in Excel

    hi everyone,
    I want to count the number of characters in the selected cell of an Excel document. Can anybody please provide the ideas with respect to this....thank you

  2. #2
    Join Date
    Apr 2008
    Posts
    4,644

    Re: How to count number of characters in Excel

    Download the tool - ASAP Utilities and install in your system. This tool helps you to tell you how many characters there are in your active cell.
    For example, if the cell contains the value 'Microsoft Excel' this tool will result 15 characters.

    In the Excel menu,
    choose ASAP Utilities Information Count number of characters in selected cell

  3. #3
    Join Date
    Apr 2008
    Posts
    2,139

    Re: How to count number of characters in Excel

    Here's the ultimate solution for you - http://support.microsoft.com/kb/187667

    This link contains the following information :

    The number of occurrences of a text string in a range of cells.
    The number of occurrences of a character in one cell.
    The number of occurrences of a character in a range of cells.
    The number of words (or text strings) separated by a character in a cell.

  4. #4
    Join Date
    Jan 2008
    Posts
    3,758

    Re: How to count number of characters in Excel

    what about this, if you want to find the number of characters in a cell A1 or say the length of cell A1, and store in a cell B1, then -

    B1 = len(A1).

  5. #5
    Join Date
    May 2008
    Posts
    3,319

    Re: How to count number of characters in Excel

    Very Simple (as mentioned by Sam.D) !! To find the number of characters in a cell, enter this formula in another cell.

    =LEN(A1)

  6. #6
    Join Date
    Sep 2011
    Posts
    1

    ThumbsUp Re: How to count number of characters in Excel

    reduced my effort a lot..
    thanks guys

  7. #7
    Join Date
    Jul 2011
    Posts
    627

    Re: How to count number of characters in Excel

    You can do that by using SUBSTITUE syntax in Microsoft Excel. The exact formula for that is - =substitute(text,old_text,new_text,instance_num). You can simply test that formula and checkback. This can be used to count words in a range in Microsoft Excel. You cannot do much in that, but it works fine. I had tested this on a table and it showed up appropriate number.

Similar Threads

  1. JavaScript to count number of images
    By Juan-Carlos in forum Software Development
    Replies: 5
    Last Post: 11-12-2009, 04:22 AM
  2. PHP - Count number of words
    By GlassFish in forum Software Development
    Replies: 3
    Last Post: 27-11-2009, 12:19 PM
  3. Count the number of times yes appears in a range in excel
    By Andy Candy in forum Windows Software
    Replies: 3
    Last Post: 17-08-2009, 12:33 PM
  4. How to count number of text occurences in Excel column
    By Anas in forum Windows Software
    Replies: 3
    Last Post: 09-06-2009, 05:01 PM
  5. How To Count The Number Of Characters?
    By Harsh01 in forum Software Development
    Replies: 2
    Last Post: 13-02-2009, 11:25 AM

Posting Permissions

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