Clear Up email addresses

I have the following email address (one sample out of 500) and i want to clear the content before ; and after ; so i will get andreas_1magazine@hotmail.com

8400;;andreas_1magazine@hotmail.com;C;0;NULL;0



I tried something with Ctr F and replace with null but i dont get what i need. Please help me.

thank you,

Andreas

What you want is to convert those data into different columns first.

In excel 2003, its in Data --> Text to Columns

Select Delimited
Uncheck Tab and check Semicolon

That should split the data and leave all emails in 1 column. Delete the rest if not required.