Macro to remove Display Text from hyperlink

I have a worksheet full of hyperlinks in a single column - I want to remove the display text in each of the cells so all that remains is the url. This is similar to manually:

• Right-click the cell with a hyperlink
• Select 'Edit Hyperlink...'
• Delete the text in 'Text to Display' box
• Click OK
• Repeat on next cell below

I recorded a macro based on the list above but I can't seem to modify it to do all cells at once.

There are over a thousand cells to do this in, all in column J. I've fumbled my way thru this for fours hours with no luck, so any ideas are greatly appreciated.

Gary

Originally Posted by DonkeyOte

You could perhaps try something along the lines of:

Please Login or Register  to view this content.

modify references as nec.

Wow. You hit it out of the park on the first try! I replaced my macro code with this, udpated the sheet name, ran it in my spreadsheet and voila - nothing but hyperlinks! You, sir, are a hero.

Thank you very much.

Gary

I had this same issue and copied this code verbatim and then just changed my Column to C. It did it in like 2 seconds exactly the way I wanted it. Thanks so much.

Now I just have to sit down and go through this code so I understand how it works in case I need to do it again.

Dear Gary, you are an absolute HERO. Thank you.