Taniquetil
New Member
- Joined
- May 24, 2011
- Messages
- 26
Is there a possible way i can use a formula to enable me to click a cell and it open up a new google search with the contents of that cell?
In column J i have school names, upon clicking i would like to perform a google search for the specified school. for multiple clicks would i be able to perform multiple searchs in new tabs?
eg
cell J37 = Blatchington Mill School
which would result in google search ---
http://www.google.co.uk/search?q=Blatchington Mill School&ie=utf-8&oe=utf-8
cell J38 = Little Heath School
which would result in google search
http://www.google.co.uk/search?q=Little Heath School&ie=utf-8&oe=utf-8
etc etc, is this possible? i can forsee it working similarly to hyperlinks to emails, but i do not want to hyperlink them manually.
Thanks
In column J i have school names, upon clicking i would like to perform a google search for the specified school. for multiple clicks would i be able to perform multiple searchs in new tabs?
eg
cell J37 = Blatchington Mill School
which would result in google search ---
http://www.google.co.uk/search?q=Blatchington Mill School&ie=utf-8&oe=utf-8
cell J38 = Little Heath School
which would result in google search
http://www.google.co.uk/search?q=Little Heath School&ie=utf-8&oe=utf-8
etc etc, is this possible? i can forsee it working similarly to hyperlinks to emails, but i do not want to hyperlink them manually.
Thanks