In Sheet1,
Put instead in C1: =A1&REPT(" ",10)&B1

And if needed, we could also use in C1:
=TRIM(A1)&REPT(" ",10)&TRIM(B1)

TRIM will remove any extraneous white spaces
present within the cells.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---