adding spaces to beginning text

I want to add blank spaces to a cell with text

My cells have up to 14 spaces
If a cell as 1 or 2 characters -I want to add 6 spaces in front of text.
If a cell as 3 or 4 characters-I want to add 5 spaces in front of text.
If a cell as 5 or 6 characters-I want to add 4 spaces in front of text.
If a cell as 7 or 8 characters-I want to add 3 spaces in front of text.
If a cell as 9 or 10 characters-I want to add 2 spaces in front of text.
If a cell as 11 or 12 characters-I want to add 1 spaces in front of text.

Does anyone know how to do this?????

Thanks BB

This should do.

=REPT(" ",LOOKUP(LEN(A1),{1,3,5,7,9,11,13;6,5,4,3,2,1,0}))&A1

Hi, Bilbo Baggins

Try this Formula in your Calc Column , and look images result check

Please Login or Register  to view this content.

20130407 b0000181.jpg

Good Luck !