TOP

GetURL Function

GETURL() Description

The GETURL() function is designed for getting website addresses from text.


Main Characteristics of the GETURL Function

Syntax:

=GETURL(Text; Entry)

Parameters:

Example of Use

The GETURL() function is easy to use. You just need to enter any text and specify the ordinal number of the required website address, and Excel (Calc) will automatically return the specified occurrence:

=GETURL(Text; Entry)

We will get the following result:

Example of using the GETURL() function
Example of using the GETURL() function

The following values are used in this example:

Download extension

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

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


This function is also available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel