how to add a row between rows of data

M

monkeytrader

is it possible to dump rows of data into a spreadsheet and automatically have
it insert a blank row between?

ex:

asjdflasjdlfjak;lslf;a
asdfiawuerpoiquwepour
asdfjlaksjdfoweur
qoiweuroqweu

i would like it to show:

asjdflasjdlfjak;lslf;a

asdfiawuerpoiquwepour

asdfjlaksjdfoweur
....
 
W

wjohnson

If your data is in a Word Document just add a paragraph return betwee
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" ke
 
Top