inserting spaces prior to characters in a cell base on the value in a different cell

Hi folks!

I am working on a file and want to add various numbers of spaces in front of a number in one column based on the value in another column. For example, if A1=2 and B2=52354325432, I want to add 2 spaces in front of the number in B2. Columns A has up to 7 different numbers and Column B could have an infinite number of values.

Thanks for any help you can offer!

That certainly gives me the formatting I desire, but I would like column B to be my "working" column. I am using this to show the indented levels on a BOM. I guess it will likley do the trick as the formating is more for others than myself. Thank you for taking the time to respond benishiryo!