If Cell Contains, then move

[Mark B]

Does anyone know if I can do this...

I have a single column (A) in a worksheet that has many
rows. I want to either copy or move every cell that
contains an @ symbol in the field to the same cell in the
next column (B).

Anyone know a quick forumula to do this?

THANKS!!!

 

[Jason Morin]

Try this in col. B:

=IF(COUNTIF(A1,"*@*"),A1,"")

HTH
Jason
Atlanta, GA

 

[mark B]

OH MAN DID THAT DO THE TRICK!!!!!!

Thanks a million!