Only show rows that contain links

[Ivanos]

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!

[#2 · Accepted solution]

One way is to filter the column by color.

[#3]

@Harun24HR sometimes the answer can be so simple...lol. Thank you!