Greetings:
Using Excel 2003, SP2
Am using the following to create text that will be used in another program.

Column 'C' has extensive indentations that greatly help the readability of
the text.
This is lost when the following function is used.
Looking for a way to keep the indenting look, perhaps by replacing the
indents with spaces. Is there a way to modify the function to do this?
Or do I have to go the way of programming?

=LEFT(TEXT(D1,".")&REPT(" ",11),11)&LEFT(TEXT(E1,".")&REPT(" ",6),6)&C1