Thread: Formula To Add Spaces Until Character Count Is 10

Hi, I'm looking for a formula that will add the space character to a cell's value until the total character count of the return value is 10, then it needs to append the contents of another cell to its value.

Ex.

Column A:
ABC
AB
ABCDE

Column B:
RED
BLUE
GREEN

Column C (result):
ABC RED
AB BLUE
ABCDE GREEN

It's a little hard to tell but in the result column row 1 has 7 spaces, row 2 has 8 spaces, and row 3 has 5 spaces. Ideas?

Try:

=A1&REPT(" ",10-LEN(A1))&B1

copied down