I received a long string of information in an email. Challenge is to get it into Excel and on individual rows. Since I couldn't use the real names I made of fake names and emails. Example of the information is as follows:

Red, Team <Red.Team@peony.com>; mail, Jail mail.Jail@peony.com>;



The above goes on and on for many names and email addresses.

When I bring this information into Excel, the information comes in all on one row.
How can I get each Last Name, First Name and email address on their individual rows? Once I can do that, I believe I can use the Text to Columns to get the Last Name, First Name and Email Addresses to their individual columns.

Thanking you in advance for your help.
Laurie B.

Perhaps save it in a text file then import in XL, using the ; as delimiter.You now have all data in one row in separate cells
Now Copy the row - Paste Special - Tranpose and everything should be in one column

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post