delimiting question

Hey- I have a txt file of names and e-mail addresses that looks like this-

Aaron Burke; [email protected]; Aaron Cottrell
[email protected]; Aaron Curnow; [email protected];
Aaron Deer; [email protected]; Aaron Gelbman;
[email protected]; Aaron Kaswell; [email protected]; Aaron
Lazar; [email protected]; Aaron Lazar; [email protected];
Aaron Lazar [email protected]; Aba2 [email protected];
Abbie Gardner [email protected]; Abby Jenkins; Acewho
[email protected]; [email protected]; Acrokat [email protected];
Acthistle [email protected]; ACTIVATE [email protected]; Acullen [email protected]; Ad Astra Per Aspera
[email protected];

As you might notice, sometimes the name is just one word (Adam), sometimes it is two (Aaron Cottrell), sometimes it is more (Ad Astra Per Aspera). I want to have only two columns- name and e-mail address. As there are about 1700 entries in the list, it would obviously be very time-consuming to do this manually- but the Text Import Wizard doesn't seem to be able to do it.

Anyone know a way I could accomplish this? Thanks for any suggestions.

Much love,
Santo
Santos Party House

You can use the Split function, and split strings at the semicolons. Then you'd need to look for the presence of the @ in each substring to know if it is the email address associated with the prior substring.

Posting a sanitized text file would help.