This is an add-on for Google Sheets that can extract texts and links from user-input range.

Sometimes we do need to extract the hyperlink from the rich text, however, currently Google Sheets has no ways to extract the links from a certain range of data. So this add-on help to solve this problem. It extracts the both the texts and links at the same time.