Can I replace different urls in selected column with "Click Here" with a Macro?

How do I create this Excel macro? Change an entire column of different clickable URLS to "Click Here"? For example: I have an entire clickable column of different URLs. I can change each of them individually to "Click Here" but that would take too long (over 6,000); and I can even record a macro to do that but all it does is record the same URL to all the fields in the column. What I want is to change all the different URLS to the display text "Click Here" for one selected column TIA.

I hope it is possible