How can I create a hyperlink in the middle of cell text?

Question

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? In other words, I'd like a single cell to look like:

click here for answer

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?

Answer 1

EDIT (2020-Aug-06): Google Sheets now supports this; see Aibol Kussain's answer.

Original answer:

As far as I can tell, Google Sheets [still] simply does not support what you are asking for. (I've looked around for it, too.)

See, e.g., https://docs.google.com/document/preview?hgd=1&id=1x_qjPL5rmSuQWW57KcwB9lg3eiykKpd8dMEaQUZbWU8, particularly where it says:

Please note: Like the other types of data and cell formatting, links in spreadsheets must be assigned to an entire cell, you cannot have just part of the text inside a cell be hyperlinked.

Also:

• https://webapps.stackexchange.com/questions/24931/a-way-to-add-text-before-your-hyperlink-in-google-spreadsheets
• https://webapps.stackexchange.com/questions/83073/is-it-possible-to-have-plain-text-and-a-link-in-the-same-cell