Text to Columns Wizard - Stopping it

[mboucher]

I am getting frustrated with the Text to Columns Wizard. After using it once on a spreadsheet, it continues to opperate whenever I paste.

Is there a way to stop it from automatically converting text to columns when I paste?

Mark

[shg]

Welcome to the forum.

Compliments of Andy Pope, a macro I keep in Personal.xls for just that purpose:

Please Login or Register  to view this content.

[mboucher]

Nice shg.

I've only done rudimentary macros. Where do I keep Personal.xls so it is available?

Mark

[shg]

See http://www.rondebruin.nl/personal.htm

[DonkeyOte]

If you ever want to do the same manually... once you've run the TtC - rerun TtC on one cell and un-check the settings you used before and click Finish...
This feature bugs me too! I for one don't really like it when XL tries to be "helpful"

[mboucher]

I got two for the price of one on this one.
Thanks so much for the code and help sheet.

Works like a charm.

Makr