| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| New text added to cell AFTER current text in same cell | Excel Worksheet Functions | |||
Hybrid Mode
