# Thread: How to count number of characters in Excel

1. Member
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. Member
Join Date
Apr 2008
Posts
4,642

## 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. Member
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. Member
Join Date
Jan 2008
Posts
3,756

## 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. Member
Join Date
May 2008
Posts
3,316

## 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. Member
Join Date
Sep 2011
Posts
1

## Re: How to count number of characters in Excel

reduced my effort a lot..
thanks guys

7. Member
Join Date
Jul 2011
Posts
623

## 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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Page generated in 1,638,766,838.70513 seconds with 17 queries