How to split excel data into columns – urgent help requested.

Hola.

I’ve got text data in the following format:

Aaron Bailey(anpaulbailey@gmail.com)
Ajay Jindia(ajia@bellsouth.net)
Alan Weinberg(adberg@att.net)
Alex C. Hernandez(al34513@hotmail.com)

And would like to use excel to break it into columns like:

Aaron Bailey anbailey@gmail.com

Some data feilds may have middle initials like the 4th row. If thats the case then:

Alex C. Hernandez al34513@hotmail.com

Help will be most apprecited.

Thx.