1. Select the column that contains the indented text.
2. Click on the Formulas tab in the ribbon.
3. Click on the "Insert Function" button.
4. In the search box, type "LEN" and select the LEN function from the list.
5. In the "Text" box, select the cell that contains the indented text.
6. Click on the "OK" button.
7. The LEN function will return the total number of characters in the selected cell.
8. Now, we need to subtract the number of characters in the cell without the indent. To do this, we'll use the SUBSTITUTE function.
9. Click on the "Insert Function" button again.
10. In the search box, type "SUBSTITUTE" and select the SUBSTITUTE function from the list.
11. In the "Text" box, select the cell that contains the indented text.
12. In the "Old_text" box, type a single space (or whatever character is used for the indent).
13. In the "New_text" box, leave it blank.
14. In the "Instance_num" box, type "1".
15. Click on the "OK" button.
16. The SUBSTITUTE function will remove the first indent from the selected cell.
17. Subtract the result of the SUBSTITUTE function from the result of the LEN function.
18. The final result will be the number of indents in the selected cell.

Alternatively, you can replace each indent with another character that you can count via formula. To do this, you can use the SUBSTITUTE function again. Here's how:

• Select the column that contains the indented text.
• Click on the Home tab in the ribbon.
• . Click on the "Find & Select" button.
• Click on "Replace".
• In the "Find what" box, type a single space (or whatever character is used for the indent).
• In the "Replace with" box, type a character that you can count via formula (e.g. "|").
• Click on the "Replace All" button.
• All the indents will be replaced with the character you specified.
• Now, you can count the number of characters in each cell using the LEN function and divide it by the number of characters in the replacement character (e.g. "|") to get the number of indents.