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!
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! Read More
