Paste list of hyperlinks from Excel into Word as a simple list rather than as a table for

WeThotUWasAToad
WeThotUWasAToad used Ask the Experts™
on
Hello,

How can you paste a list of hyperlinks from a spreadsheet or table into a Word document and lose the table but retain the hyperlinks?

For example, suppose you have a list of 5 hyperlinks in Excel. How can you paste that list into Word so that the links still function (as links) but are in a simple list rather than a table?

I see several paste options which remove the table but they also remove formatting (including the hyperlink function) and simply leave you with the text.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant and developer
Commented:
The easiest thing to do is probably to paste the links as a table.. ie just paste them.

And then user the "convert to text" button in word to remove the table but leave its contents. This button is in the "table layout" ribbonImage8.jpg
If the two step approach is annoying you could also create a macro that does both steps, and assign it to a button on the quick access toolbar.

Author

Commented:
Thanks Neil. That's a perfect solution. I've never noticed or used that Word function and the second step is not a problem. I just couldn't figure out how to do it at all.
Neil FlemingConsultant and developer

Commented:
Glad to be of help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial