Get email addresses in my spreadsheet into columns instead of rows

Get email addresses in my spreadsheet into columns instead of rows: "Copy the email addresses from Notepad and paste them into Microsoft Word. Notice that there are a number of spaces between each email address. Highlight one of these spaces and click Edit > Copy.
Click Edit > Replace, the Find and Replace window will open.
Place your cursor in the Find What field and press Ctrl-V. This will paste the blank spaces into the Find What field.
Place your cursor in the Replace With field and type ^l (Press Shift-6 to get the "^", then press the L key to get the "l").
Click Replace All, the email addresses will now be in column format.
Copy the email addresses from your Word document and paste into a new Excel file."



'via Blog this'