Extracting email chain email address and converting to Excel column

**Leah_Hael** · 12-28-2012, 12:15 PM

Hello,

I am hoping there is a macro or rule to help me.

What I have is a extremely long list of email address from an Outlook email and I need to transfer them to an Excel column so I can export. If I paste the copied emails into Excel it combines them all into one massive cell.
From there I am not sure how to record a Macro or rule that will successfully record and transfer the data I want from the cell. I hope this makes sense - any suggestions would be greatly appreciated, otherwise I will have to continue doing it by copy and paste.

Thank you so much in advance!

**FDibbins** · 12-28-2012, 12:23 PM

have you tried using text-to-columns to at least make a start at breaking them up?

**Spencer101** · 12-28-2012, 12:23 PM

I presume there is a common separator between each email address in the list? Therefore you could use the "text to columns" option and then transpose the row into a column.