ADD SPACES via FORMULA: baced on a number in adjacent cell

[itr674]

I need to add a certain number of spaces based on a number in an adjacent cell.

Am concatenating several cells into one, and using Courier New font to line things up, but need to add a number of spaces to the end of the next to last concatenation based on number in an adjacent cell.

 

[DanteAmor]

Change 25 by the number of spaces needed

=A1&REPT(" ",25)&B1

 

[itr674]

Thank you!

 

[DanteAmor]

Youre welcome & thanks for the feedback.