Hello, Sorry if this should go into the Excel forums and not Word, I'm working between both programs.
This issue is driving me mad. I have an excel database with 21,000+ rows of data and three columns, the third being a hyperlink to a web-page. The current goal is to export this data into Word and reformat it there as a user friendly PDF. The data in Word should be tab delineated with no tables and keeping all the original hyperlinks.
A) Is there a way to paste data into word keeping the hyperlinks, without pasting a table? Or a way to remove tables in Word and keep the hyperlinks?
B) Is there a way to copy the data from Excel into Word in a way that keeps the hyperlink without modifying it as a link back to the excel document?
Perhaps this is straight forward but right now its baffling and searching the internet isn't finding many helpful posts or perhaps I'm simply searching the wrong keywords. So I thought asking directly might yield a useful response and leave something out there for someone to find that may be in a similar jam.
Bookmarks