contador web Skip to content

How to count characters in Excel | Productivity

Excel allows you to count cell characters in a document from a formula. The ideal resource for cases where you need to find out how many numbers, spaces, letters, and other characters were used in a single cell. The formula needs the location of the cell and, after its execution, can offer the automatic sum of the present characters.

The procedure works for Office 365, Excel Online, Excel 2019, Excel 2016, and Excel 2013 spreadsheets. Check out the tutorial we prepared to see how many characters are in a cell in Microsoft Excel.

Excel: Ten Function Tips to Make Everything Faster

Excel on PC Photo: Carolina Ochsendorf / dnetc         Excel on PC Photo: Carolina Ochsendorf / dnetc

Excel on PC Photo: Carolina Ochsendorf / dnetc

Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc

Step 1. Select a cell and double click to enable the write option for formulas;

When modifying an excel cell to use the character counting function Photo: Playback / Marvin CostaWhen modifying an excel cell to use the character counting function Photo: Playback / Marvin Costa

When modifying an excel cell to use the character counting function Photo: Playback / Marvin Costa

Step 2. Use the formula "= NM.CARACT (text)" (without quotation marks). Where it says "Text", add the cell. A practical example would be "= NM.CARACT (B13)". B corresponds to column and 13 to cell number. For the result to be displayed, press the "Enter" key on your keyboard;

By adding the formula to count characters in an excel cell Photo: Reproduction / Marvin CostaBy adding the formula to count characters in an excel cell Photo: Reproduction / Marvin Costa

By adding the formula for counting characters in an excel cell Photo: Reproduction / Marvin Costa

Step 3. The sum result appears in the cell in which you used the formula. The result shows the total number of characters in the column.

Result presented by formula that counts characters in a column in Excel Photo: Reproduction / Marvin CostaResult presented by formula that counts characters in a column in Excel Photo: Reproduction / Marvin Costa

Result presented by formula that counts characters in a column in Excel Photo: Reproduction / Marvin Costa

Ready. Take advantage of the tip to quickly know how many characters are in an Excel cell.

How to save spreadsheet after adding VBA Codes? Ask questions on the dnetc forum.

How to delete all blank lines in Excel at once

How to delete all blank lines in Excel at once