Need to remove many hyperlinks while keeping most. Please Help Me…

[notrandom]

I am so sorry if this has been answered before, but I truly cannot find anything in regards to my situation.

I recently copied an entire web page with a bunch of hyperlinks I DO want to keep, and many others I DO NOT.

The few hyperlinks I DO want are spelled normally with simple wording.
The hyperlinks I DO NOT want have a “[edit]” in the title of the links.

Please, Anyone… For the love of god, or universe… or no god… (I respect every individual’s choice of poison)

Please help me remove all hyperlinks with “[edit]” in the wording. If it has [edit] and it’s a hyperlink, I need it gone.

I guess I’m looking for sort of a “Specific hyperlink removal macro” If anyone can please help me!
Again thank you all in advance.
Please help me. I’m pulling my hair out… I’ve been bald for 10 years…

 

[Jonmo1]

Welcome to the board...

Try using the Autofilter.
Select Custom - Contains - [edit]

And delete visible rows.


Hope that helps.