In this tutorial we will learn about How to use LEN Function in Excel
Example:
I have some digits written inside the cells and want to count the digits inside a particular cell
So here we will be using LEN Function in Excel to count the digits inside a particular cell
1. Write =LEN and press the Tab Key
A single parameter text will appear which means the text for which to calculate length
2. Select the cell as text
3. Close the bracket and press Enter
4. Excel will count the digits inside a particular cell
Note – If there is a space between the numbers then also it will be considered as character
5. Drag the cell to the bottom to count digits of other cell
