ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Special Character (https://www.excelbanter.com/excel-discussion-misc-queries/101083-special-character.html)

Henry

Special Character
 
Hi.

I need to add a "tab" as text in a cell. So when i save a file in text,
each line has an additional "tab" imbeded. How can I do it?

Thanks!

Dave Peterson

Special Character
 
It won't look good, but you could use:

="some text" & char(9) & "some more text"



Henry wrote:

Hi.

I need to add a "tab" as text in a cell. So when i save a file in text,
each line has an additional "tab" imbeded. How can I do it?

Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com