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?