delete certain rows based on their partial cell content

**WasWodge** · 01-30-2011, 01:49 PM

Hi there, if anyone can help I am looking for a method to delete (Not filter) certain rows based on their partial cell content. If you look at column A in the attached sample I want to delete any row where the contents of the cell ends "A01". In this sample it should delete rows 5 and 7. Any help will be much appreciated

**Marcol** · 01-30-2011, 02:19 PM

Use the filter facility

Filter > Text Filters > Ends with A01

Select the result and delete the rows

Remove the filter.

Hope this helps

**WasWodge** · 01-30-2011, 02:34 PM

Cheers Marcol,works perfectly on proper worksheet as well as sample. I didn't know that the end with function existed in filter so you do learn everyday. Now to ask the next question from the result in the programming forum............................