| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you find and replace tab characters in a cell in Excel?
I am getting tab characters in cells in a spreadsheet loaded from a DB.
Is there a way to find tab characters? Word has a swell "special" pull down and escape sequences for control characters but Excel doesn't have anything obvious. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you find and replace tab characters in a cell in Excel?
in the *search for what* space, hold down the ALT key, enter 0009 from the
numeric keypad, let up on the ALT key, that puts a tab character in there. "Ryk" wrote: I am getting tab characters in cells in a spreadsheet loaded from a DB. Is there a way to find tab characters? Word has a swell "special" pull down and escape sequences for control characters but Excel doesn't have anything obvious. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| How can I replace 2 of 5 characters within an cell in MS Excel? | Excel Worksheet Functions | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
