How to Count Characters in Excel

With Text Toolkit for Microsoft Excel

With the Text Toolkit for Excel, you can easily count characters or words in the selected cells. In this manual, find out how to use the Count Characters utility.

  1. To run the tool in Excel, go to the Home tab and click the Text Toolkit icon:
    This is the Text Toolkit icon.
  2. Select Count Characters:
    Select Count Characters.
  3. You will see the Count Characters pane. Select your options and click the Insert Results button:
    The Count Characters pane.
  1. Select the range of cells that contain characters you want to count.
    Note. Columns with numbers of characters will be inserted to the right of each of the initially selected columns in the range. For example, if you count characters in column A, the result numbers will be placed to a new column B.
  2. Tick the Count Characters radio button to get the number of all characters in the selected cells.
  3. If you don't want the tool to count spaces, make sure there's a check mark next to Exclude spaces.
  4. Pick Count the following characters to count only the specified symbols and enter these symbols into the input field.
  5. Tick Case-sensitive if you want the tool to distinguish the case of text you entered from text in your cells. For instance, with selected Case-sensitive, "E" and "e" will be recognized as different values, though with unchecked Case-sensitive, they will be identified as the same values and counted.
  6. Select Count words to get the number of all words in a cell.
  7. Tick the Insert as formula box to get the result inserted as a formula.
  8. If you tick the Enable Undo box, the Undo button will appear:
    Tick Enable Undo to be able to Undo.
    As soon as you hit Insert Results, the Undo button will become clickable and you'll be able to undo the changes made by the add-in:
    Undo the changes.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at