Unexpected Results Pasting Text After Using TextWizard
Article ID: 127132
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q127132
SYMPTOMS
When you copy and paste text from another application to Microsoft Excel,
if the TextWizard has been used for the current session of Microsoft
Excel, data may be parsed using the delimiter that was used in the
TextWizard.
CAUSE
The TextWizard will remain active for an entire session of Microsoft
Excel.
If you parse text using the TextWizard, and you choose delimited text with
the space as the delimiter, as soon as you paste in new text, it will be
parsed by spaces.
WORKAROUNDS
To work around this problem, use either of the following methods.
Method 1
Choose a cell that has a word with no spaces. Start the TextWizard.
To start the TextWizard, on the Data menu, click Text to Columns. In
Step 1 of the Wizard, under Original Data Type, click Delimited, and
click the Tab check box only. Click Finish.
Method 2
Save any files that are open and restart Microsoft Excel.
REFERENCES
"Microsoft Excel User's Guide," pages 724-725
Additional query words: 97 import text to columns data XL
Keywords: kbprb KB127132