How do you find and replace tab characters in a cell in Excel?

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an option to view Special (control) Characters in Excel 2 3
Show or Hide control characters in a cell (using Excel 2007)... 0
Formula to validate characters within a string of data in aparticular cell 1
How do I use standard notepad (unicode) font for special character 2
Removing Special characters in Excel 8
how do I use macro to find and replace unicode characters 6
How do I find replace special characters? 1
Why can't I get more than 255 characters in one cell in Excel 07? 1

Top