Convert link correctly to hyperlink

When I enter into a cell, the only part that is clickable is 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.

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

Set Hyperlink

Another way - use HYPERLINK() function

=HYPERLINK("";"Martin Bissitt CARGILL")


Using the HYPERLINK function was good an worked thankyou.