View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike M Mike M is offline
external usenet poster
 
Posts: 4
Default if data is "A", then paste it to another cell

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!