Tab text in cell

  • Thread starter Thread starter donbowyer
  • Start date Start date
D

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.
 
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.
 
Hi Joel
Many thanks for the input
--
donwb


Joel said:
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.
 
Back
Top