Excel Hyperlink with Cell Parameter

[Cyril Maurer]

Hi 

I would like to create an Excel Table where I have cells with different content. 

With this content I would like to have a linkt to the search with the values of the cells.

For example:

https://jira.com/issues/?jql=text%20~%20%22(Value from CellA1)%22

Does anyone has an idea how to do that?

Thank you,

Cyril

[RianS]

Looks like this can be done pretty easily. You can look at this link for more information. It basically involves using the HYPERLINK() function and you structure it like this:

=HYPERLINK("https://www.google.com/search?q="&A1&"&oq="&A1")

This will turn into the following assuming cell A1 has the value "Search Term",

https://www.google.com/search?q=Search Term&oq=Search Term

You can put a function around the cell such as SUBSTITUTE(A1, " ", "%22") to replace any spaces in the cell value with the url friendly character.

[Cyril Maurer]

Thank you very much.

I was really close but I the "& was missing.