| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND TAB, Replace with Spaces (3) or ...
What character to be used to enter a "tab" in the find box?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FIND TAB, Replace with Spaces (3) or ...
It would be the same as =char(9) in a cell, but alt-0009 didn't work for me.
BEEJAY wrote: What character to be used to enter a "tab" in the find box? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FIND TAB, Replace with Spaces (3) or ...
Neither for me, but this does work.
Sub Remove_Tab() Selection.Replace What:=Chr(9), Replacement:=Chr(32), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False End Sub Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 10:55:02 -0600, Dave Peterson wrote: It would be the same as =char(9) in a cell, but alt-0009 didn't work for me. BEEJAY wrote: What character to be used to enter a "tab" in the find box? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace double spaces with Hard return | Excel Worksheet Functions | |||
| Excel: replace all 2 spaces to FF/LR in column of text | Excel Discussion (Misc queries) | |||
| How can I replace spaces in text cells (excel) with underscores? | New Users to Excel | |||
| Why does not Excel 2003 Replace comand romove spaces from cell contents? | Excel Worksheet Functions | |||
| How can I replace zeros with blank spaces during calculations plea | Excel Worksheet Functions | |||
Linear Mode
