Copy and Paste Word Doc to Excel with data in Columns

  • Re: Copy and Paste Word Doc to Excel with data in Columns


    That's not really a Word document. It looks more like a table copied from a website and pasted into Word.


    It would probably be more sensible to re-evaluate how the document is produced rather than trying to code around the limitations of its present structure.


    My opinion only...


    EDIT - Considering post #3, my excuse is it was late when I posted :)

  • Re: Copy and Paste Word Doc to Excel with data in Columns


    Try this..


    Highlight the text in your Word doc..


    Go to Insert Tab... then Table > Convert Text to Table...


    Then.. highlight all data in your table (CTRL + A) and then go to your Excel Worksheet and Right Click > Paste (Keep Source Formatting or Match Destination Formatting).. either one will do..


    That should get that data pasted into columns..

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!