Tab text in cell

[donbowyer]

Excel 2003 / Win XP
How can I Tab text in a cell.
Using the Tab key just tabs the Cursor but doesn't take the text with it.
I've tried all combinations of Shift/Ctrl/Alt with Tab but no luck.
I realise a suitable macro could do it, but wanted to avoid.

 

[Joel]

This code will put a REAL tab ascii code 9 into the cell.

="a"&CHAR(9)&"b"

You won't see spaces in the excel spreadsheet, but it will be intrepeted in
other programs as a tab.

 

[donbowyer]

Hi Joel
Many thanks for the input
--
donwb

This code will put a REAL tab ascii code 9 into the cell.

="a"&CHAR(9)&"b"

You won't see spaces in the excel spreadsheet, but it will be intrepeted in
other programs as a tab.