Convert link correctly to hyperlink

[owencook]

When I enter https://www.aif.adfa.edu.au/showPerson?pid=46221 into a cell, the only part that is clickable is https://www.aif.adfa.edu.au/showPerson IE, all after the ? is ignored.

Is there a trick to making the whole link clickable?

The data comes from parsing a website, so I could manipulate the url to meet libreoffice formatting.

[JohnSUN]

Select Hyperlink command from the Insert menu or press Ctrl+K

Another way - use HYPERLINK() function

=HYPERLINK("https://www.aif.adfa.edu.au/showPerson?pid=46221";"Martin Bissitt CARGILL")

[owencook]

Using the HYPERLINK function was good an worked thankyou.