The information in this article applies to:
- Microsoft Word for Windows versions 2.0, 2.0a, 2.0a-CD, 2.0b,
2.0c, 6.0, 6.0a, 6.0c
SUMMARY
When you paste a Microsoft Excel spreadsheet in Word for Windows,
sometimes Word merges two Excel cells into one table cell. This
happens if both of the following are true in the Excel spreadsheet:
- The information in the left cell does not fit in the column (the
text word wraps, or it is truncated).
-and-
Workarounds
- Type a space in the blank Excel spreadsheet cells before you copy
and paste them in Word.
-or-
- In Word, choose Paste Special from the Edit menu. Select
Unformatted Text from the Data Type list and choose the Paste button.
This pastes delimited text in your Word document, which you can
select and convert to a Word table.
Steps to Reproduce Problem
- In an Excel spreadsheet with default column width settings, type
"this is a test" (without the quotation marks) in cell A1.
- Press TAB twice and type "123" (without the quotation marks) in
cell C1. Cell B1 should be blank.
- Select A1 through C1 (three cells). From the Edit menu, choose
Copy.
- Switch to Word for Windows. In a Word document, choose Paste from
the Edit menu. Notice that only two cells appear in Word instead of
three. Word has merged cells A1 and B1.
We are researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
|