Excel 2007 : Deleting rows that end with some value

**cde1983** · 05-13-2010, 01:10 AM

I need help figuring out how to delete rows that contain a number for column A ending in a particular 4-digit value (i.e.,2000). Column A contains a single 17-digit number with the first 3 digits representing a country code, the next 8 digits representing a weather station, etc. I must delete all rows ending with 2000.

**royUK** · 05-13-2010, 01:20 AM

Try this

Please Login or Register  to view this content.

**cde1983** · 05-13-2010, 12:42 PM

THANKS! That worked. What a relief that I don't have to do that by hand!

**royUK** · 05-13-2010, 01:50 PM

Glad it helped. If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save