Wizard

R

RTP

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

IanRoy

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
 
G

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
 
G

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
 
Top