creating a list off of email

There must be something that separates the addresses, like a comma, or a space, or a semi-colon, or even a line break. Whatever these characters are, you can use them to break up the list. Paste the list into your spreadsheet in cell A1, then click on Data, Text to Columns. Select the Tab, or Space, or other option that fits the separator, then complete the wizard.

Excel will spread the addresses across row 1, so you then need to copy row 1 and move your cell marker to cell A2 and clickon Edit, Paste Special, Transpose to paste them down column A.