+ Reply to Thread
Results 1 to 2 of 2

Excel Data to Word as Tab Formatted, Keeping Hyperlinks

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    New York
    MS-Off Ver
    2019
    Posts
    1

    Excel Data to Word as Tab Formatted, Keeping Hyperlinks

    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.
    Last edited by jamesjamis; 03-01-2021 at 11:29 AM.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Excel Data to Word as Tab Formatted, Keeping Hyperlinks

    Why not simply paste the table into Word, then use Word's table tools to convert the table to text?

    Besides which, what does it matter whether the table structure is preserved when outputting as a PDF?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert formatted Pivottable from Excel to Word
    By Netzup in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2020, 02:32 PM
  2. [SOLVED] Word 2016 is default, but hyperlinks in Excel file open Word 2010
    By 6StringJazzer in forum Excel General
    Replies: 2
    Last Post: 11-29-2016, 11:29 PM
  3. Having excel export a formatted word document
    By rockthecasbah121 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2016, 04:26 PM
  4. Pull data from Excel into a formatted word Doc, Is it possible?
    By ervinr82 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-24-2015, 12:18 PM
  5. [SOLVED] Hyperlinks - keeping link with data, not with cell
    By jeffandnicole in forum Excel General
    Replies: 6
    Last Post: 03-13-2014, 04:16 AM
  6. [SOLVED] How to import formatted Excel data into a readable Word document?
    By 12 Major Chords in forum Excel General
    Replies: 4
    Last Post: 01-06-2014, 12:59 PM
  7. Bringing formatted word content into excel cell
    By zkazi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2009, 02:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1