Aug 19, 2010 at 11:01 PM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Aug 20, 2010 at 09:02 AM
I am having the most troubling of times trying to find the google answer to this question. I stumbled upon this forum and many of you seem extremely well versed in Excel formulas/macros. I have a spreadsheet with a single column of data (A1:A4000) containing a bunch of web "GET" requests. I want to delete every row that does not contain ".pdf" in the GET request line. Is there a formula I can use?
I don't care if it copies over the ".pdf" rows to another column or worksheet or deletes if NOT .pdf. I just want to get the ".pdf" data isolated from the rest. Please help me :(