Hello all! Thanks in advance for your help - I am very grateful.

I have a large text file with names and emails which I am trying to unify so that I can add them as contacts into mailchimp. It looks like this:

"Allen Shawn" <AShawn@bennington.edu>
"Jane Austen" <spettee@verizon.net>
"Kessler, Judy" <jkessler@vno.com>
"Kipper, Judith" <jkipper@iwa.org>
......
.....

The names don't have a unified format. How do I use wildcards correctly to change everything to "Firstname Lastname"?

Thank you!