Adding spaces to a text string?

[MichaelRSnow]

I have many rows of data over 2 columns (A & B), which I need to format in column 3 (C) i.e. add 6 characters, space then 7 characters</SPAN>

Some of the data in the columns may only be 2 characters long so I need to pad it out to 6 with 4 spaces, is there are formula which exists that can check the length and add spaces to the end of the text string to hit the max length required?

Example

A</SPAN>	B</SPAN>	C</SPAN>
LEN = 6</SPAN>	LEN = 7</SPAN>	LEN = 6 + SPACE + 7</SPAN>
123456</SPAN>	1234567</SPAN>	123456 1234567 (LEN = 14)</SPAN>
22</SPAN>	12345</SPAN>	22 12345 (LEN = 14)</SPAN>

<TBODY>
</TBODY>

 

[VoG]

Try

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

 

[kevatarvind]

sorry not getting what actually you need

can you post some more data with desired result ?

 

[MichaelRSnow]

Try

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

Perfect, as always, thank you