Excel: Text Pasted from Word for Windows Gets Truncated

 Last reviewed: April 17, 1996
Article ID: Q79551
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0

SYMPTOMS

When a long string of text is copied from Word for Windows and pasted into a single cell in Microsoft Excel for Windows, the text is truncated and pasted into the row(s) below. The problem occurs when Word for Windows pastes the text into the Clipboard. The Clipboard wraps the text, and when Microsoft Excel pastes the information into a cell, it is truncated.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open Microsoft Word for Windows and Microsoft Excel.

  2. Activate Word for Windows and create a document 12-inches wide. You can do this by choosing Paragraph from the Format menu and entering 

          -6"

    in the Indentation From Right text box.

  3. Type a string of text the width of the page.

  4. Select the entered text and choose Copy from the Edit menu.

  5. Minimize Word for Windows and activate Microsoft Excel.

  6. Select cell A1 and choose Paste from the Edit menu.

The text will be truncated and the remaining portion(s) will be pasted into A2, A3, and so on, as if carriage returns had been inserted throughout the string of text.

STATUS

Microsoft has confirmed this to be a problem in Windows version 3.0, and 3.1. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.1 2.10 2.1c 2.10c 2.1d 2.10d 3.0 3.00
3.1 3.10 4.0 4.00 5.0 5.00 cut

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.