Unwanted tabs

C

Crisfam

I have a very large document created in Access and with multiple fields (45).
I copied this into spreadsheet to do some cross-field search and replace
routines then copied the completed text into Word.
Question: How do I get rid of the unwanted tabs created in the spreadsheet?
Or do I have to go through the whole Word file and manually delete each one
to create continuous text for each entry?
 
P

Peter T. Daniels

If you want no tabs at all anywhere, you can simply use Find/Replace
(Ctrl-H). In the upper Find What? box, type ^t (caret t), and in the
lower Replace With box, type nothing at all, and click Replace All.

If you need to replace each tab with a space, then in the Replace With
box, type a single space (you won't see anything in the box, but the
cursor will move over a little).

If you then end up with two or more spaces in a row here and there,
then do a Find/Replace with two spaces in the upper box and one in the
lower box; repeat until it reports 0 replacements.
 

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

Top