I'm copying a table from the internet that contains hyperlinks and I want to store just the text from the hyperlink.
How can I convert the hyperlink to text ?
Thank you for your help
I'm copying a table from the internet that contains hyperlinks and I want to store just the text from the hyperlink.
How can I convert the hyperlink to text ?
Thank you for your help
hi,
Instead of pasting the table (into Excel), try using Edit - Paste Special & choose Text.
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Good morning SuitedAces
Pop this code into a module, select the range with your hyperlonks, and go to Tools > Macro > Macros, select "test" and click on Run.
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thank you both for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks