Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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: 44
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
  #2  
Old 08-09-2020, 12:30 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Pasting from Excel to Word 4 columns: data is truncated Windows 10 Pasting from Excel to Word 4 columns: data is truncated Office 2019
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

In Word, there is an option called "Wrap text" in the Cell Options dialog box.
Attached Images
File Type: png WrapTextOptionCellOptions.png (139.3 KB, 23 views)
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 08-09-2020, 03:22 PM
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: 44
Andersn2 is on a distinguished road
Default

Thank you very much for replying.

I know about the wrap option. I have it turned on but nothing wraps after the paste operation. The truncated data is already lost and is not restored after I turn wrap on.

--If I create an empty 4 column table, all the data gets pasted into the first column. That is why I am using "columns" in Word 2007. (See attachment).

--If I setup Word to have 4 columns before the paste operation, and then paste the data, each Excel row is truncated into a single truncated line per 'cell'. Turning wrap on after that happens does not restore the lost text.

--If I paste the data into a blank Word document, all the data is correctly pasted. If I now select all and tell Word to use 4 columns, it converts the selected text into 4 columns. but again the data is truncated into single shortened lines per 'cell'. If I click on table properties, and check, I see that wrap is selected, it still does not wrap and the text remains truncated into single shortened lines per 'cell'

That's why I am asking if this is a bug and how to work around it.
Attached Images
File Type: jpg Columns.JPG (43.2 KB, 24 views)
File Type: jpg Truncated.JPG (39.7 KB, 24 views)
File Type: jpg Wrap is on.JPG (35.7 KB, 23 views)
Reply With Quote
  #4  
Old 08-09-2020, 03:29 PM
Guessed's Avatar
Guessed Guessed is offline Pasting from Excel to Word 4 columns: data is truncated Windows 10 Pasting from Excel to Word 4 columns: data is truncated Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It looks like your table cells are wider than the visible column. Try adjusting the width of the table to no more than the width of the column.

I would actually convert the table to text as there is no benefit in showing this inside table cells anyway.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 08-10-2020, 03:11 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: 44
Andersn2 is on a distinguished road
Default

Thank you again for replying.

The table was created automatically by Word. I did not set the cell sizes. I just told Word I wanted the text in 4 columns and Word set the cell sizes.

The Excel column is not very wide. Wrap is on in both Excel and Word but Word is just not wrapping the contents when the lines are longer than the cell width. That is the problem and I do not know how to force Word to wrap the cell contents. Seems to be a problem with "wrapping" if columns is used.

The reason I need to do this is because 80,000 rows of text content is a lot of data which would run into thousands of pages in Word. Many of the Excel rows are relatively short but a few are very long and need to be wrapped. So, by dividing the excel text into 4 columns in Word brings the Word document down to much fewer pages (about 400 instead of thousands) which is the final objective. I need to cram this large mount of data into as few pages as possible in Word. But Word is just not wrapping the text within the cells. Seems to be a bug.

Can you think of another way to do this? Put the content from Excel into 4 columns that wrap in a word document?
Reply With Quote
  #6  
Old 08-10-2020, 03:59 AM
Guessed's Avatar
Guessed Guessed is offline Pasting from Excel to Word 4 columns: data is truncated Windows 10 Pasting from Excel to Word 4 columns: data is truncated Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I disagree - you did (inadvertently) set the cell sizes because you pasted from Excel, where the column width was specified.

Please test what I suggested earlier rather than just dismissing it.

Have a closer LOOK at your own screenshot. It says that the table cell width is 6'11" inches yet your ruler shows that the column it is trying to fit in is just over one inch.

If you change the section column count to 1 then you might see just how large the table column width is.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 08-10-2020, 05:07 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: 44
Andersn2 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I disagree - you did (inadvertently) set the cell sizes because you pasted from Excel, where the column width was specified.

Please test what I suggested earlier rather than just dismissing it.

Have a closer LOOK at your own screenshot. It says that the table cell width is 6'11" inches yet your ruler shows that the column it is trying to fit in is just over one inch.

If you change the section column count to 1 then you might see just how large the table column width is.
Thanks for replying Guessed.

Please forgive me. Rather than dismiss what you said, I just did not understand what you meant or how to do it. This is all above my head. I'm just now getting an inkling of what you meant and it makes sense.

But, how do I "adjust the width of the table to no more than the width of the column"? Where do I do that? Do I do it in Excel or Word?

To keep the page count down, I need to cram the Excel data (it's all text) into 4 columns on the Word page.

Thank you for helping.
Reply With Quote
  #8  
Old 08-10-2020, 05:18 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: 44
Andersn2 is on a distinguished road
Default

OK, I found the setting to adjust the cell width. I need to adjust it to the maximum width possible for having 4 columns in that page. How do I find that maximum size other than trial and error?
Reply With Quote
  #9  
Old 08-10-2020, 05:26 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: 44
Andersn2 is on a distinguished road
Default

ALL done. Thank you so much Guessed.
You solved it for me. Sorry for misunderstanding. I was too focussed on the missing text.
Reply With Quote
Reply

Thread Tools
Display Modes


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 08:51 AM.


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