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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Removing rows with spaces at beginning of cell? 8
Macro to delete an entire row with cells missing a specific chartacter 2
Creating a macro to hide rows in a specific range 0
Macro for deleting rows and serialising the remaing rows 1
A macro to hide rows 5
macro to include "user select" 3
Need to delete last value in column but not delete entire row 4

Back
Top