Microsoft Excel is words most widely used data analytics tool. Its most widely used even before widespread usage of term data analytics.

Many times we have to deal with hyperlinks in excel. If you have a text from which you want to extract hyperlink, there is no readymade formula available. However, you can do it multiple ways, simplest way is to create your own custom fucntion

1. Press Alt+F11
2. Insert->Modul
4. Function GetURL(cell As Range, Optional default_value As Variant)
'If cell does not contain a hyperlink, return default_value
GetURL = default_value
Else
End Function