hello frds,
I have approx 1000 emails in a text file
text file format is as below
name (name@gmail.com) ; tarun (tarun@gmail.com); rock (rock@yahoo.com); ...etc ...etc

i want this in excel file with name as different column and email in different column

Name Email
tarun tarun@gmail.com
rock rock@yahoo.com


i tried all the method but i am not able to do it ,Please help me

thanks