Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-09-2020, 03:52 AM
Andersn2 Andersn2 is offline Pasting from Excel to Word 4 columns: data is truncated Windows 7 64bit Pasting from Excel to Word 4 columns: data is truncated Office XP
Advanced Beginner
Pasting from Excel to Word 4 columns: data is truncated
 
Join Date: May 2012
Posts: 51
Andersn2 is on a distinguished road
Default Pasting from Excel to Word 4 columns: data is truncated


Word and Excel 2007
Windows 10 laptop with 8 GB ram.

I am trying to copy/paste text data from a single column of an Excel spreadsheet into a blank Word document which is set to have 4 columns.

The Excel column has 70,000 rows of data. The copy/paste operation takes forever to complete but it eventually does. The data goes correctly into the 4 columns of the Word document.

But, the pasted data is truncated in the Word document. By that I mean that in some cells the data would need to "wrap" in the Word cells to fit it all in, but it does not wrap. It just gets truncated into a single shortened line in those cells. I've changed the Word table properties to have wrap enabled, but that does not wrap anything and does not restore the lost data.

How can I copy data from Excel and paste it into Word without some of the text being lost? Is this a known bug? Is wrap broken in Word columns? Is there a work around?

Thank you.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting linked data from excel into PowerPoint dcmontva PowerPoint 0 06-25-2019 02:11 AM
Pasting from Excel to Word 4 columns: data is truncated Trying to create an invoice by cutting and pasting data from one excel speadsheet to another famres Excel Programming 8 03-21-2015 05:59 PM
Pasting from Excel to Word 4 columns: data is truncated Copying and pasting values with unequal data columns grexcelman Excel Programming 5 12-05-2014 11:36 AM
Copying and pasting acount data into Excel as text will not reformat to a number or currency ncbergst Excel 3 09-04-2014 11:29 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft