ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Convert Tabs to Spaces (https://www.excelbanter.com/excel-worksheet-functions/132609-convert-tabs-spaces.html)

BEEJAY

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