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

  • Thread starter Thread starter asf
  • Start date Start date
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!
 
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
 
Back
Top