Delete whole if the cell ends with something

**mthem2003** · 08-18-2009, 04:46 PM

I am trying to create a function or a macro to Delete whole if the cell ends with something ( for example , it ends with @com)

any ideas

**Paul** · 08-18-2009, 05:05 PM

Are you looking to loop through a range of cells? In a column? In a row? When deleting the cells, do you want the entire row deleted? Just the cell? If just the cell, do you want surrounding cells to shift up or to the left?

**Cheeky Charlie** · 08-18-2009, 05:46 PM

=right(<cell>,4)="@com" evaluates to TRUE where the last four characters of the cell referred to are @com. Copy this in an adjacent column, apply data -> filter -> autofilter, filter the test columns for true and delete your cells or delete their contents as needed.

CC