Wizard

[Guest]

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???

 

[Guest]

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

 

[Gord Dibben]

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

 

[Gord Dibben]

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