Hi,
I have a spreadsheet with thousands of urls listed - I want to find all urls that have the term 'answerhandle=&' within them - is there a way I can find them & how do I move them into a different workbook?
Thanks in advance
Have a look at using the SEARCH function like:
=ISNUMBER(SEARCH("answerhandle=&",A1))
This will return TRUE if it finds a match and you can then use autofilter and copy just the matches to a new worksheet.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi CantonMassive.
My solution is using IF & FIND functions.
Take a look to the attachement.
Regards
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thinking about it you can just use a custom autofilter and forget about the formula altogether.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
This is great thanks for the helpOriginally Posted by Domski
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks