Hi Joel--1st THANKS!

2nd--could i get a little clarification pls?

Here's what i did:
highlight the column with data
paste formula in formula area
a new blue box pops up and i left where it is and i tried dragging over the
data cells
click enter
error

what am i doing wrong?
thanks!!!

"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!