Excel: How to add TAB character

[jonnysnow]

I haven't found this in the FAQ or when searching the forum:

How can I add a literal TAB character in Excel?

Right now I want to replace every instance of a double-space with a TAB. How can I enter a TAB character in the Replace: window for text replacement?

While I'm at it, let me ask how do you put a TAB character into a cell?

Thanks!!

 

[AnotherHiggins]

- In the Find What field, press [Space] twice
- In the Replace With field, hold down the [Alt] key and then use the number pad at the right side of your keyboard to type in 0009 (the ASCII character for Horizontal Tab)
- Replace All


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.