GetURL function for LO Calc

GETURL() Description

The GETURL() function is designed to retrieve website addresses from text.

Main Features Functions GETURL

Syntax:

=GETURL(Text; Entry)

Parameters:

• Text: Text from which you need to get website addresses.
• Entry: The sequence number (entry) of the required address. It can also have a negative value, which means searching for an entry from the end of the string. If the value is 0, it returns all entries.

Example Usage

The GETURL() function is easy to use. You just need to enter any text and specify the serial number of the desired website address, and LO Calc will automatically return the specified entry:

=GETURL(Text; Entry)

We will have the following result:

This example uses the following values:

• Text: A3 - Text from which you need to get website addresses ("Technology is everywhere, from ...") .
• Entry: B3 - Display all entries (0) .

Download extension

You can use the function GETURL() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

After that, this function will be available in all files that are opened in LibreOffice Calc .