The information in this article applies to:
SYMPTOMSThe versions of Microsoft Excel listed above may incorrectly parse text files that contain curly quotation marks ("smart quotes"). WORKAROUND
For Microsoft Excel to correctly parse the data, you must manually set
the points at which the text string should be parsed. The steps below
describe how to do this:
Or, before you import the text file in Microsoft Excel, open the file in any text editor that has a replace feature and replace the smart quotes with normal quotation marks. MORE INFORMATION
In most word processors, when you create a comma-delimited file, text
strings can be kept together by enclosing the string in "smart" quotes
or in normal quotation marks, as in the following example:
When you parse the above text string in Microsoft Excel, "NE" correctly remains part of the text string "123 Main Street, NE," and the text strings "123 South Street" and "WA" are correctly considered two separate text strings and parsed into separate columns. However, if the text string above contains "smart" quotes instead of normal quotation marks, the text may not be parsed as expected. If the text file is imported with the delimiter set as a comma, the text string will be parsed as if the quotation marks were not there. That is, in the example above, the text "123 Main Street" is entered in one cell and "NE" in another. REFERENCES
"User's Guide 2," version 4.0, pages 150-151 Additional query words: 4.00a XL4 XL3 curly curled
Keywords : |
Last Reviewed: December 23, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |