Inserting text from word into Excel 2002

Hi Guys,

I have a bunch of email addresses in Microsoft word i'd like to insert into Excel. Basically i want to have each email address in a individual row. The problem im having is when i copy and paste the email addresses from word into excel, excel is putting them all into one row, and not individual rows.

I've tried various 'paste special' functions to no avail. Im wondering if this is even possible or i might have to do it manually and copy and paste each address into individual rows, i hope not, as theres about 200 email addresses.

If any can think of another way i havent tried, im all ears!

Many thanks

Curtis