Put this formula in the cell next to the email address.

Assuming your first itme is in cell ref A1;

="www."&RIGHT(A1,(LEN(A1)-(FIND("@",A1))))

You can copy and paste-special values once you have filled in the details,
to get rid of the formula.

"Rob" wrote:

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