How to create a Hyperlink based on Cell Contents
I've tried searching the forums for an answer, but had no luck. Will try my luck posting...and maybe it'll also help someone else as well:
-> In Excel Cells L4 to L9999, I would like to have Excel have that cell Hyperlinked of a Google search of the contents which were entered in that cell. (or, if that same cell can't be Hyperlinked, then a neighboring cell is OK)
-> So, for example, if cell L4 contained the word: "testing",
I would like to be able to click on that text in the cell to open a browser and take me to: "http://www.google.com/search?q=testing"
...I hope this can be done without writing a macro, (maybe by a formula instead?) BUT, if it's the only way of doing it, then yes, please, in that case, I would LOVE to know how to write/enter the macro.
Thanks SO much for your help!!