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.