Count the indent

[Etphonehome]

Hi,

I have a column of Narratives with indent which shows their hierarchy. Which formula I should use to see how many space that narrative have at the beginning.

E.g.

Finance dept. 0 space Hierarchy 1
Accounting. 2 spaces Hierarchy 2
AR. 4 spaces Hierarchy 3
AP. 4 spaces Hierarchy 3
Internal Control. 2 spaces Hierarchy 2
System. 4 spaces Hierarchy 3

Thanks.

 

[jasonb75]

You could use something like

=LEN(A1)-LEN(TRIM(A1))

But if there are any trailing spaces, or multiple spaces between words you will get an incorrect result.

 

[Etphonehome]

Thanks jasonb75. But I do have space between words, is there any other formula that can avoid this potential error?

 

[jasonb75]

As long as the spaces are only single it will work, i.e. "Finance dept" has only 1 space between the words.

 

[Etphonehome]

Got it, will try. Thanks.

 

[Etphonehome]

Got it, will try. Thanks.

Thanks jasonb75, it works perfectly.