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?