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?