How to parse a link in Google Sheets?

Question

Google Sheets

Is it possible to somehow automatically parse hyperlinks to the anchor and the link itself?

For example:
Source link:
link

I would like to receive:
URL: site.ru
Anchor: link

Answer 1

The name (anchor) is displayed by the function T()
To display the address, it was yandexed: https://stackoverflow.com/a/64565474
Table with an example .