If your data is in a Word Document just add a paragraph return between
each line.
Select All that you want to paste into Excell and paste.
Each paragraph return will give you a blank row.

If you have a long list in Word - do a find and replace.
In the "FIND" Menu - Select "MORE" - "SPECIAL" - Then paragraph mark
In the replace Section - Replace with "Paragraph Mark" Paragraph Mark"
If you type it in manually in the find box type the following ^p
In the replace box type type the following ^p^p
Must use lower case "p" and the other symbol is on the number "6" key


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2297508