XL: Unexpected Results Pasting Text After Using TextWizard

ID: Q127132

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows

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


Keywords          : 
Version           : WINDOWS:5.0,95,97; MACINTOSH:5.0
Platform          : MACINTOSH WINDOWS 
Issue type        : kbprb

Last Reviewed: July 14, 1999