How to extract url from hyperlink column in a Google Doc spreadsheet

Posted 6 months ago
=index(SPLIT(SUBSTITUTE(FORMULATEXT(A1),"=HYPERLINK(""",""),""","""),1,1)