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.
