Tab text in cell
 

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.
--
donwb

Tab text in cell
 

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" wrote:

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.
--
donwb

Tab text in cell
 

Hi Joel
Many thanks for the input
--
donwb


"Joel" wrote:

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" wrote:

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.
--
donwb