Open Office Calc:Convert list of text urls into links

I have a list of text urls in, how i can convert all of them into clickable links?

Solution

HYPERLINK(linkaddress; celltext)

Open Office Calc:Convert list of text urls into links
Make row number of cell in Libreoffice a variable
Multiple IF AND statements in one line with OpenOffice Calc
Execute SQL query on Calc spreadsheet without using Base
How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,...)
Openoffice.org Calc - Assigning value to variable
Formula to return random string from list of strings?
Libreoffice Calc Basic macro to combine sheets with different number of columns
Table containing the count of multiple columns?
read data from multiple spreadsheets into database
How to run a formula until it meets a certain criteria?
How to subtract a time constant in a LibreOffice/OpenOffice/Excel formula?
Find last column with data and return the header of that column
LibreOffice Calc: Find a cell by value
highlight duplicate Value in Open Office org Calc
Excel Having issues with an ODS file created with SODS
How do you use " (double quotes) in a formula in OpenOffice VBA? For instance with Replace()
Highlight duplicate values
extract number from cell in openoffice calc
Using OLE, remove all sheets except first one from a OpenOffice/LibreOffice Calc document, without using sheet names
Create floating button to add/subtract values to/from cells in spread sheet
How to run a script from another document
Libreoffice/Openoffice Calc - append string to cells
Error with Roo . Any gems to parse .ods files
Charts created by EPPlus 4.1 library in .xlsx format are not displaying in openoffice or libreoffice
LibreOffice Calc / OpenOffice Calc / Excel: How to display a negative time duration?
How to merge two columns in open office calc
Assign Category Values according to wildcards in assignment table
OpenOffice Calc sum of number less then a value
Size difference between python generated csv and converted xlsx file