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, when in Text, by replacing the
indents with spaces. My inititial test indicates that spaces will "stay",
when converting to text - The "space" created by tabs, disappears.


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