In FireFox, you can create a keyword that you can type into the address bar and have it search for you. For instance, I have a google search set to where I can type "g batman" into the address bar, and a google search for "batman" will come up.
Now, I would like to create a hyperlink in Excel that uses cell data to search for the value in that cell...here's what I thought would work:
=hyperlink("g" &E13, "Link")
Cell E 13 has a search term - like "Birthday cake"
I had hoped that this would open FireFox, and have "g Birthday cake" in the address bar, then proceed to "enter'" that as the URL and subsequently I'd get my google search.
However, this doesn't happen as Excel doesn't know how to open that request (the "g" is throwing it off)
How can I make it so where it actually puts "g Birthday cake" in the address bar and then searches that...
Thank you for any ideas or help or tips.
PS: I know I could do something like instead of having ''g'', put ''http://www.google.com/search?q='' and then it would add Cell E13's value at the end, and do a google search properly (http://www.google.com/search?q=Birthday cake) , but I need it to actually use "g Birthday cake" as the URL.
TL;DR:
Instead of =HYPERLINK("http://www.google.com") which opens www.google.com in the address bar in FireFox, I want it to open "r Birthday Cake" in the address bar of Firefox. Instead of opening, I get an error.
Bookmarks