OpenOffice Calc: How to concatenate string in hyperlink function

Question

Hi to all,
I would like to add a column in my OpenOffice Calc spreadsheet.
In particular, this column should contain a hyperlink to a query on Google.

For example: if in A1 I have the string "The gladiator", I would like have column B1:

"www.google.it?q=The Gladiator"

So I can click and open the browser to see how that "film" is (yes, it is a simple film database).

Thank you!

Answer 1

You have two options:

The & operator:

=hyperlink("http://www.google.com/search?q="&A1)

or the concatenate() function:

=hyperlink(CONCATENATE("http://www.google.com/search?q=",A1))

The HYPERLINK() function handles URL encoding for you.