VBA to extract search string from URL

UDF
B2:
=GetKeyWords(A2)

Please Login or Register  to view this content.

Hi jindon

Thanks so much for your quick reply.

I've tried your code with my original list and it works well on the URLs that have a plus sign between the words, e.g. online+bike+builder.

However, in my original list there are a lot of URLs where the search terms don't have a plus (+) sign between words, e.g.
http://www.bing.com/search?q=how to calculate kj to calories&FORM=AWRE&adlt=strict
http://www.google.com/search?q= what is a doberman pinscher &safe=active
http://au.search.yahoo.com/search?p=people that don't eat meat&vm=r

As well as URLs where the search terms appear at the end...
http://google.com/search?q=what was mummification

Is there a way to include a solution in the code for these as well?

Thanks
darls15

Can you upload a workbook with all the possible variation of data and the results that you want?

So that I can see if it is possible or not.

Hi jindon

Here you go - Example_URLKeywordExtract_2.xlsx.

I've tried to capture all the variations of the URLs in the attached, including some that are the results from searches within sites. I'm not sure whether these ones will be possible however thought I'd include them as well.

Your help with this is much appreciated. Thank you.

And you desired results?

Apologies, I have updated the spreadsheet to include desired results

I'm out now, I will reply in a couple of hours.

Try change to function to

Please Login or Register  to view this content.

@jindon, my apologies for taking so long in getting back to you on this. I've been away working in a different area and have just returned. This is beyond brilliant and I can't thank you enough. I've tested it and it works perfectly! Thank you thank you

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.