I have .txt data that I am selecting and trying to copy into an Excel
spreadsheet. When I go to copy the data in, it is just copying in and the
wizard is not popping up. Why is this happening???

Hi RTP,
If you are not seeing the "paste options" button, which contains a link to
the wizard, go to Tools Options Edit, check "Show Paste Options buttons."
Regards,
IanRoy

"RTP" wrote:

I have .txt data that I am selecting and trying to copy into an Excel
spreadsheet. When I go to copy the data in, it is just copying in and the
wizard is not popping up. Why is this happening???

RTP

The Text to Columns Wizard pops up only when importing/opening a *.txt file.

A straight copy and paste of text will not trigger the Wizard.

Gord Dibben Excel MVP

On Wed, 29 Dec 2004 14:07:07 -0800, RTP wrote:

I have .txt data that I am selecting and trying to copy into an Excel
spreadsheet. When I go to copy the data in, it is just copying in and the
wizard is not popping up. Why is this happening???

Thanks for the reminder IanRoy.

I have that option turned off as a personal preference and forget about it as
a path to the TTC Wizard.

Gord

On Wed, 29 Dec 2004 14:35:02 -0800, IanRoy
wrote:

Hi RTP,
If you are not seeing the "paste options" button, which contains a link to
the wizard, go to Tools Options Edit, check "Show Paste Options buttons."
Regards,
IanRoy

"RTP" wrote:

I have .txt data that I am selecting and trying to copy into an Excel
spreadsheet. When I go to copy the data in, it is just copying in and the
wizard is not popping up. Why is this happening???