Separate a list to columns

I currently have a list of email adressess in a Word document that I need to export into individual cells in Excel. Is there a way to do this without writing a VB code? Here is an example:

[email protected]: [email protected]: [email protected]: etc, etc

mpquin,

Copy the string of emails from word. Paste into A1 in the worksheet. Go to Data>Text to Columns. Select Delimited in the first step. Click Next. In the next step select the Other option and type in a colon. Click Next. In the last step click Finish. This will parse the email addresses across row 1 in your worksheet.

You could also convert the text to a table in word first and then paste right into Excel. Go to Table menu, Text to Table, select the colon for the separator. Then copy the table and paste to excel. If you want to paste into a column vertically then paste using Paste Special and choose Text from the options.

HTH

Steve

Thanks Steve!

Is there a way to populate into the the information into separate cells in Column A only? I tried the "text to columns" but I have way to many email addresses .

Hi,

You could also convert the text to a table in word first and then paste right into Excel. Go to Table menu, Text to Table, select the colon for the separator. Then copy the table and paste to excel. If you want to paste into a column vertically then paste using Paste Special and choose Text from the options.

Convert to a table in Word first, Paste Special and choose the Text option. This will paste vertically in the column.

HTH

Steve