Formula for Adding Spaces Before Text

Hi Excel Forum Team,

I needed help in figuring out a formula that will automatically take a manually keyed in cell text and automatically in the formula cell return the same text with three blank spaces in front of the original text.

For example, in cell A1 I would type in the name of a month like, "November" and in cell B2 the formula would return that month plus the addition of 3 blank spaces before it like, " November".

If someone knows how to do this and advise me on it that would be great!!!

Thank You.

Garrett

That's it!!!

Thank you for helping me solve it!

Garrett