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
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
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?
=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
I meant deleting the whole row, if the cell on a specific column ends with something , for example "@.com"
read cheek charlies post it works fine, just select the visible rows using the row numbers and right click delete row
Last edited by martindwilson; 08-18-2009 at 09:19 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks