Thanks very much for this! Can you also help me on this one - I want to
split 1000+ email ID's copied into 1 cell, into separate cells within a
column.. Thanks - Rob

"JE McGimpsey" wrote:

One way:

B1: =MID(A1,FIND("@",A1)+1,32000)
C1: ="www."&B1

In article ,
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