View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default if data is "A", then paste it to another cell

You can add another column to extract the webgsite from the rest of the email
address like this

=MID(H1,FIND("@",H1)+1,LEN(H1))

which will look for all text after the "@". Then sort on the new column.
You can then quickly remove certain groups of rows from the worksheet.

"mike m" wrote:

i have a list of 8000 e-mail addresses and i need to remove 700 of them that
contain a certain address (ex: @yourcompany.com). Does anyone know how to
create a formula that would look for them, then remove them from their
original cell and move them to a different cell???

Thansk!