Count number of characters in Excel

Ready-made formulas for char or word count

The add-in does exactly what its name suggests: counts words and characters in Excel. You can calculate all symbols or words in a cell as well as find out the number of specific letters. The results can be returned as values or reusable formulas.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Count Characters for Excel 2019, 2016 - 2010

With Count Characters you will

  • Count all characters in Excel Return the number of symbols in each cell of the selected range.
  • Get a word count in Excel Find out the number of words in each cell within a certain range.
  • Count specific characters in selected cells Check how many times a particular char appears in your dataset.
  • Insert the result as value or formula Have the results as static numbers or updatable formulas.

How to count letters and words in Excel

Count number of characters in Excel cells
Count number of characters in Excel cells
Tick off one checkbox to paste the result as a formula
Tick off one checkbox to paste the result as a formula
How to count specific symbols in Excel
How to count specific symbols in Excel
Insert a formula to count specific symbols
Insert a formula to count specific symbols
How to count words in Excel and get the result as a formula
How to count words in Excel and get the result as a formula

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Count Characters and what do I need it for?

The Count Characters add-in allows you to count the number of characters and words in Excel cells. You can either get the total char count in selected cells or tally the occurrences of a specific symbol. The tool lets you insert the result as a number or formula.

Can't I count number of characters in Excel without any add-ins?

Yes, you can. It's probably no big deal to count all characters in a cell by using a LEN formula. To do a word count in Excel, be prepared to build a more elaborate formula by combining various functions like LEN, TRIM, and SUBSTITUTE. Counting specific characters could be even trickier.

With the Count Characters tool, the number of your actions is reduced to a couple of mouse clicks.

How to count characters and words in Excel?

  1. Click the Count Characters icon under the Ablebits Tools tab.
  2. Select the range.
  3. Choose what you need to count: characters, specific symbols, or words.
  4. Decide if you want the result as a formula and whether you need a backup worksheet.
  5. Click Insert results.

See a more detailed description here.

I need the result as a formula, can the add-in do that?

Yes. The add-in inserts a simple LEN formula for a char count and a more complex formula for word count.

Where does the add-in put the results?

Count Characters inserts a new column to the right of your selected range and places the result next to each cell with the original data.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported


  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.