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.

Learn more
This tool is part of
Ultimate Suite
Count Characters for Excel 2016 - 2007

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
Count number of characters in Excel cells
Tick off one checkbox to paste the result as a formula
How to count specific symbols in Excel
Insert a formula to count specific symbols
How to count words in Excel and get the result as a formula

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Count Characters

  • 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

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

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.
Excel add-ins and Outlook tools - Ablebits.com