I have a google spreadsheet, where I want to link each cell in a range to the google search page, where the search term is the text in this particular cell. So if I have a cell with content 'Bikes' I want to turn it to a link that will search for 'Bikes' in Google.
How do I achieve that short of manually going over each cell in the range and turning it into a link?
This is what I have:
Note that the list is much longer than a few cells.
This is where I want to arrive:
These will hyperlink to
Since there are a hundred of cells I would like a more practical method than inserting a hyperlink manually for each cell.