Macro to delete an entire row with cells missing a specific chartacter

A

asf

Hi all, this forum is a lifesaver.

Quick question, I know how to remove a row if there is a specifi
occurrence but how do I do the opposite, remove a row without th
specific occurrance?

For example I have an email list with Col. A = Name, Col. B = email.
need to remove all the rows with emails in col. B without the "@
symbol (basically get rid of invalid email entries).

Thanks!
 
H

Harald Staff

Hi Asf

This is far more useful if you figure it out yourself, since you're pretty
close. How do you remove rows if there IS an @ in B column ? (Post code or
method if you're stuck)

HTH. Best wishes Harald
 
Top