Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Google spreadsheets, it is possible to add a hyperlink to a cell as:

 =hyperlink("www.google.com";"search the web")

This will show the text search the web which will hyperlink to Google. However, I am wondering:

  1. How can this rule be inserting into the middle of a cell?
  2. Is it possible to make a rule like this in your spreadsheet so that anytime you type, "search the web", you automatically get the hyperlink to Google. You don't have to keep adding =hyperlink("www.google.com";"search the web")
  3. If that's possible, is there anyway to add a parameter to the URL?
share|improve this question

The only sense in which a hyperlink can be placed in the middle of a cell is by centering the cell. If what you mean is a cell containing a hyperlink and also other plain text, that is not currently possible.

Parameters can be used in a URL. A URL is simply a string and can be a constant value or can be built up from functions or other cells. For example:

= hyperlink( "https://www.google.com/search?q=" & B2 )
share|improve this answer

Try this:


A13 uses whatever text is in the cell to search. It is also at the end of the formula to name the cell the formula is in.

I've got “near my address” (well, “near _______”, whatever your address is) in cell L13, just remove &l13 to get rid of it. It searches Google for the text in cell a13 near my location.

This searches Google Maps for the text near my location:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.