email list format correction in excel

hello frds,
I have approx 1000 emails in a text file
text file format is as below
name ([email protected]) ; tarun ([email protected]); rock ([email protected]); ...etc ...etc

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

Name Email
tarun [email protected]
rock [email protected]


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

thanks

Originally Posted by oeldere

Use text to column and use a space as delimitator.

thanks for reply
but it will stay in same row..i want name in first column and email in second column