Re: how can I automatically remove the blank lines from a Word docume.

[Bill Foley]

Not in Word that I know of, but you can try the following:

1. Select your text in Word and press CTRL-C to copy
2. Switch to Excel and press CTRL-V to paste
3. Select all you just pasted and press CTRL-C to copy
4. Switch to a new Sheet, click "Edit", "Paste Special", select the "Skip
Blanks" option.
5. Get rid of the first Sheet.

Not sure if it will give you what you want, but it might be worth a try.

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor - XP
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
Check out Word FAQs at: http://word.mvps.org/FAQs/General/index.htm

"LSUSmiley" <LSUS...@discussions.microsoft.com> wrote in message
news:843FE725-6975-4CB6...@microsoft.com...
> Using MS Word Professional 2003 on XP. I opened a SQL results file in Word
> and now want to copy the results to rows in excel. The results file has
lots
> of blank lines that I'd like to automatically delete instead of manually
> going thru and taking them out. Is there a feature in Word that will
remove
> blank lines?

[Jay Freedman]

Do an Edit > Replace, using
^p^p
in the Find What box and
^p
in the Replace With box. Click the Replace All button. You may need to hit
the button several times to get rid of instances of three, four, or more
empty paragraphs.

An alternative is to click the More button in the Replace dialog and check
the Use Wildcards box. Then change the Find What expression to
[^13]{2,}
and use the same ^p for the Replace With expression. This means to search
for any group of two or more paragraph marks (ASCII 13 characters) and
replace with one. Now you need only click Replace All once.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org