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:
    Click Text Toolkit.
  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 Change Case 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. Pick Count the following characters to count only the specified symbols and enter these symbols into the input field.
  4. 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.
  5. Select Count words to get the number of all words in a cell.
  6. Tick the Insert as formula box to get the result inserted as a formula.
  7. 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.