Only show rows that contain links

Hello everyone,

I have an excel sheet with 2400 rows in column A. 60% of these rows are hyperlinks. That's the only data I want to see. Would that be possible?

So I don't want to extract the hyperlink and turn it into text, I just want the rows that contain the hyperlinks to stay. The rest can be deleted. See the following example:

Ps. I am using Excel on a Mac. Hope someone can help, thank you!