Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.