Microsoft KB Archive/140755

= WD: Multicolumn Text from Word Becomes One Column in Excel =

Article ID: 140755

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Excel 5.0a for Macintosh
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 97 Standard Edition
 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q140755



SYMPTOMS
When you copy multicolumn text from Word and paste it into Microsoft Excel, the text appears in one column in Microsoft Excel.

If you click Paste Special to paste the text in Microsoft Excel, the text still appears in one column, no matter which format type you select.



CAUSE
Columns are controlled by section-level formatting. If the last paragraph mark in the document or if the section break following the columns is not copied with the rest of the selection, the section formatting, and thus the column formatting, is lost.



RESOLUTION
NOTE: The methods below let you move the information in two columns to Microsoft Excel, where the information will appear the way it does in Word. However, none of the methods below actually places information in a second cell.

Method 1 (All versions of Word except for Word 97 for Windows)
If the document has no other text that you want to copy to Microsoft Excel, follow these steps:
 * 1) On the Edit menu, click Select All to select the entire document (including column formatting information).
 * 2) On the Edit menu, click Copy.
 * 3) Switch to Microsoft Excel and click Paste Special on the Edit menu.
 * 4) Choose either Microsoft Word Document Object or Picture. Click OK.

Method 2
Convert the columns to a picture, and paste the picture into Microsoft Excel:
 * 1) Highlight the multicolumn text.
 * 2) Click the Copy button.
 * 3) Click the New Document button.
 * 4) In the new document, click Paste Special on the Edit menu.
 * 5) Click Picture. Click OK.
 * 6) Select the picture, then click the Copy button.
 * 7) Switch to Microsoft Excel. On the Edit menu, click Paste Special.
 * 8) Click Picture. Click OK.

Additional query words: xl

Keywords: kbbug kbhowto kbinterop KB140755

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.