Remove table structure but retain hyperlink function of a list in Word


How can a long list of hyperlinks residing in an Excel spreadsheet be pasted/converted to a simple non-table list in Word AND retain their hyperlink function?

I found the following menu option in Word:

Insert > Tables > Convert Text to Table

But how can I go the opposite direction so that the table structure is removed and it just becomes a simple list of hyperlinks.

Who is Participating?
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Select the Table --> Table Tools --> Layout --> Under Data Section (top right) --> Convert to Text --> Choose Tab and click OK.
Ryan ChongCommented:
we probably simply read the content of cells and treat them as hyperlinks.

so when you doing the looping, we just simply create new hyperlink objects in word document.
Rob HensonConnect With a Mentor Finance AnalystCommented:
Copy from Excel.
In Word choose Paste Special > choose HTML Format. This pastes as a table of hyperlinks. Then as Neeraj has quoted above, Select the Table and convert to text, I chose Paragraph Marks rather than Tab and got the same result.

This assumes that the display text in Excel is actually the hyperlink address rather than an abbreviated text.

Rob H
Rob HensonFinance AnalystCommented:
Not enough information to confirm an answer

Both mine and Neeraj's suggestion answers the question exactly as asked.
Rob HensonFinance AnalystCommented:
But that is not what your proposal to close the question said.

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
So I posted an objection.

Do you now want us to do something different? Please specify more clearly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.