Editing Multiple E-Mail Addresses...

[foofightin]

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 (e-mail address removed)
(e-mail address removed)
(e-mail address removed)
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?

 

[Govind]

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]

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

 

[foofightin]

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

Thanks

 

[Govind]

Hi,

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

regards

Govind.

 

[Gord Dibben]

foo

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

Select the original column.

Data>Text to Columns>Delimited by @

Delete the column you don't want when complete.

Gord Dibben Excel MVP