I have a column of email addresses in an excel spreadie.

I want to split those email addresses so that I have the full email address
in one column and everything behind the €œ@€� in another column.

Example


Full email ID = ;

1 column = ;

Next column = xyz.co.uk;

It would also be helpful to add another column which added the €œwww€�

ie new column = www. xyz.co.uk

Thanks