How to Count the Number of Characters in a Cell in Excel 2013


Excel 2013 has a lot of formulas that can help you to analyze your data. Often these formulas allow you to perform mathematical operations on your cells, and formulas make it easy to update those operations if you happen to change the data in one of those cells.

Occasionally, however, you might need to use Excel to do something that would be inconvenient to do manually, such as count the number of letters, numbers, or special characters that are contained within a cell. Fortunately Excel 2013 has a formula that can automate this character count, thereby saving you the hassle of needing to manually count all of those characters.

 

Excel 2013 – How to Count the Characters in a Cell

The steps below are going to show you how to use a formula to count the number of characters in one of the cells of your spreadsheet. Like other formulas in Excel, if you copy the cell with the formula and paste it into the rest of the cells in a row or columns, Excel will automatically update the cell references to count the characters in other cells, too.

Step 1: Open the Excel spreadsheet containing the cell with characters that you want to count.

 

Step 2: Click inside the cell where you want to display the amount of characters in your target cell.

select the cell where you want to display the character count

 

 

Step 3: Type =LEN(XX) but replace the XX part of the formula with the cell location that you want to count. In the picture below, for example, the formula would be =LEN(A2).

how to count the number of characters in a cell in Excel 2013

 

 

Step 4: Press the Enter key on your keyboard to execute the formula. You should then see the count of characters in the target cell.

completed LEN formula in Excel 2013

 

 

Additional Notes

  • Excel will count spaces as characters with this formula.
  • You can get a total character count for multiple cells by adding the SUM function. For example, a formula that counted the total number of characters in cells A2 through A6 would look like =SUM(LEN(A2),LEN(A3),LEN(A4), LEN(A5), LEN(A6))

 

Summary – How to count characters in cells in Excel

  1. Click inside the cell where you want to display the character count.
  2. Type =LEN(XX) and replace XX with the cell that you want to count.
  3. Press Enter on your keyboard.

 

Do you have a sequence of cells that all contain a space or special character, and you are looking for a way to remove those? Learn how to remove the first character from a cell with a formula and save yourself some time in editing your data.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.