Setting up Contacts in a Distribution List - Outlook

[midfieldgeneral11]

Good Afternoon Everyone, can you help?

I have a list of email addresses in word like the example below which need to be placed in Outlook as a distribution list?

Thought this might work if the data was like in word with a mail format of the email address with a comma after each email address.

But how do I do it?

I am not able to copy these emails straight into a distribution list ! Can I do it without typing the emails out all again.

Problem is I have 40 spreadsheets with a list of emails in each which could range from 4 to 500!

Simon.brown@yahoo.co.uk,Simon.brown@yahoo.co.uk,Simon.brown@yahoo.co.uk,
Simon.brown@yahoo.co.uk,Simon.brown@yahoo.co.uk, Simon.brown@yahoo.co.uk

Is there a import option I can use!

Hope you can help

Simon