I have an Excel sheet that contains text/nonclickable URL links mixed in with other text (see attachment), and I need to test those hyperlinks to see if they're broken or not. Is there a function that will extract the hyperlink text (ex. all text starting with https: and ending with .html) and/or convert it to a clickable link? I'm looking for an alternative to having to manually locate, copy and paste each URL into a browser, since there's over 1000 rows and some contain cells more than one hyperlink.
Thank you
Bookmarks