I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?

Hi,

Lets say the email id is in cell A1, use this formula in cell B1

=MID(A1,FIND("@",A1)+1,100)

Regards

Govind.

foofightin wrote:
I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?

The formula works but instead of just editing A1, it needs to check A1 to
A1000 odd, and then display all the answers. How does one do this?

Thanks

"Govind" wrote:

Hi,

Lets say the email id is in cell A1, use this formula in cell B1

=MID(A1,FIND("@",A1)+1,100)

Regards

Govind.

foofightin wrote:
I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?

sorry ignore my last post I just copied and pasted. d'oh

Thanks

"foofightin" wrote:

The formula works but instead of just editing A1, it needs to check A1 to
A1000 odd, and then display all the answers. How does one do this?

Thanks

"Govind" wrote:

Hi,

Lets say the email id is in cell A1, use this formula in cell B1

=MID(A1,FIND("@",A1)+1,100)

Regards

Govind.

foofightin wrote:
I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?

Hi,

Lets say your data is from A1 to A1000, then enter this formula in B1
and copy it down till B1000

regards

Govind.

foofightin wrote:
The formula works but instead of just editing A1, it needs to check A1 to
A1000 odd, and then display all the answers. How does one do this?

Thanks

"Govind" wrote:


Hi,

Lets say the email id is in cell A1, use this formula in cell B1

=MID(A1,FIND("@",A1)+1,100)

Regards

Govind.

foofightin wrote:

I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?

foo

Insert a column adjacent(right of) the original column.

Select the original column.

DataText to ColumnsDelimited by @

Delete the column you don't want when complete.

Gord Dibben Excel MVP

On Thu, 28 Oct 2004 01:33:01 -0700, "foofightin"
wrote:

I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted.
i.e


In my finished format, all that should be left are the domains
i.e harrys.com
harrys.com
elspeths.com
To save time is there a function that allows me to do this in 1?