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

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

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

"Cin" wrote:

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

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

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