20
Excel Formulas to Count Total Characters in a Cell ~ Simple Tutorial!!
Assume that you have a list of values in a range, and you need to count the total number of characters in each cell including the space character. How could you deal with this task in Excel? Today I introduce you to some formulas to solve this problem. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
![](https://res.cloudinary.com/practicaldev/image/fetch/s--mDtxhx7D--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Count-total-characters-in-a-cell.png)
- If you want to count the total number of characters in a cell, then you can use the below formula.
=LEN(a1)
- LEN – In Excel, the LEN function is used to find the length of the text string.
- A1 – It represents the input value.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Refer to the below example image.
- Here, we will enter the input values in Column B.
- Now we need to find the total number of characters in each and every cell.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--ESL898Lo--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-15.png)
- Select any cell and type the above-given formula.
![](https://res.cloudinary.com/practicaldev/image/fetch/s---lRXlFsW--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-19.png)
- Finally, press the ** ENTER** key, you can get the result as shown below.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--F0367szY--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/06/Result-18.png)
![](https://res.cloudinary.com/practicaldev/image/fetch/s--dgbkYCIy--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://s.w.org/images/core/emoji/13.0.1/72x72/1f91e.png)
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
- Excel Formulas to Count specific word in a range ~ Easy Tutorial!!
- How to Count missing values in a list in Excel Office 365?
- How to Protect All Cells with Formulas using Macros in Excel 365?
- Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!
- Excel Formulas to Count Line Breaks in A Cell ~ A Complete Guide!!
20