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

A sample file might help but perhaps along the lines of:

Please Login or Register  to view this content.

in the above Hyperlinks are assumed to be listed in Column A and are not being generated via HYPERLINK function.

Hello DonkeyOte,
Thanks for the reply. I have included a small sample (fishing rods) as an attachment. What I want is to change all the urls in the column under "website" to "Click Here". The attachment is a smaller version with just four websites but I would like to do it for a larger amount of urls in the column.

Thanks so much for your help I have searched everywhere online and noone seems to know. You're my last hope.

The code provided should do what you requested you just need to change Columns(1) to Columns("C") (or 3 but in retrospect using a letter is more transparent)

Alternatively, if you prefer to avoid VBA, you could use formulae in an adjacent column and hide Column C, eg:

Please Login or Register  to view this content.