Assign Indent Number depending on leading spaces !!!

[ionelz]

In column A, I have strings with Leading spaces !
I want to assign a code number (indent number) to B , driven by Leading spaces in A :

I want to compare LEN(of leading spaces in A) and assign indent level function of LEN

If Len(leading)=0, Then 0
If next Len(Leading)= say 3, Then 1
If next Len(Leading)= say 4, Then 2
If next Len(Leading)= say 7, Then 3

up to 10 leading spaces, possibilities

[Pete_UK]

Do you have other spaces within the strings in column A ?

Pete

[ionelz]

No, string do not have any other spaces like "inside of string"
I also know that I have 8 characters in A (8 without leading spaces) so if len(a)=8 there are no any spaces, then assign 0

[popipipo]

Please Login or Register  to view this content.

With this formula you can count leading spaces

[ionelz]

So how to assign Indent ?
If LEN(A1)-LEN(TRIM(A1))=0 THEN 0
Now I have to compare them...

Like :
If LEN(A1)-LEN(TRIM(A1))=say 3 THEN 1
If LEN(A1)-LEN(TRIM(A1))=say 7 THEN 2
If LEN(A1)-LEN(TRIM(A1))=say 11 THEN 3

[popipipo]

With vlookup you can do that.