![]() |
Convert Tabs to Spaces
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 |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com