The GETURL() function is designed for getting website addresses from text.
Main Characteristics of the GETURL Function
Syntax:
=GETURL(Text; Entry)
Parameters:
Text: The text from which website addresses should be extracted.
Entry: The ordinal number (occurrence) of the required address. It can also have a negative value, which will mean searching for the occurrence from the end of the string. With a value of 0 - it returns all occurrences.
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:
The following values are used in this example:
Text:A3 - The text from which website addresses should be extracted ("Technology is everywhere, from ...").