Quick excel question

[tres]

I have a column of email address

I'm trying to remember how to seperate this into

[email protected] | name@ | domain.com


Any ideas?

 

[tres]

Both replies have helped hugely, thanks chaps!