XL5: TextWizard Output Defaults to Active Cell

ID: Q111352

5.00 WINDOWS kbusage

The information in this article applies to:

SUMMARY

The Text To Columns command uses the currently active cell as the default cell specified in the Destination box in Step 3 of the TextWizard. The destination output defines the upper-left corner of the output range.

This is by design.

MORE INFORMATION

When you parse a range of cells using the Text To Columns function, the output will begin at the cell specified in the Destination box; the default for this box is the active cell.

This default is different than in earlier versions of Microsoft Excel. In earlier versions of Microsoft Excel, when you use the Data Parse or Smart Parse commands, the upper cell of the selected range is always the upper- left corner of the output.

NOTE: In earlier versions of Microsoft Excel, Data Parse is a built-in fixed length parsing tool; Smart Parse is a delimiter-based parsing tool provided by the Add-In file FLATFILE.XLA.

If you want to replace the original data with the parsed information, specify the upper cell of your selected range in the Destination box of Step 3 of the TextWizard. To cause the TextWizard to use this location, select the range to be parsed from top to bottom (in order to make the upper cell the active cell).

REFERENCES

"User's Guide," version 5.0, Chapter 42, "Converting Text to Columns"

For more information about converting text to columns, choose the Search button in Help and type:

    text, converting to columns

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996