GetURL function for Excel (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 Excel (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 .

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