Text to columns will not shut off.

[Gerald Cornforth]

Once I use Text to Columns in a spreadsheet, it automaticly does it to
everything I copy. There is no way to turn it off. "Help" does not have
anything even vaguely related to Text to Columns. I have never found
anything in Help that ever helped me solve a problem I was having with a
Microsoft product. I don't think a Microsoft employee will ever see this
email and if they did they wouldn't care if this problem was ever fixed.

 

[JE McGimpsey]

Feel better now?

I suspect there's not much in Help (there's a very little, under
"Separate text across columns") is because there's a wizard, which is
supposed to walk you through the process.

How are you copying? Do you mean that when you paste, something happens
automatically to run the Text to Columns wizard? If so, do you have any
event macros in your worksheet/workbook?

 

[Ken Wright]

It's a pain true, but you can get round it by simply doing another text to
columns on any bit of data, fixed width and no breaks. Awkward, annoying yes,
but impossible no.

 

[Dave Peterson]

Or the OP could use delimited and uncheck all the delimiters.

 

[Ken Wright]

LOL - Very true

Or the OP could use delimited and uncheck all the delimiters.

 

[Dave Peterson]

I guess it depends on how many lines excel guesses vs how many checkboxes I have
to uncheck.

(I guess I like the delimited since it's easier to explain over the phone!)

LOL - Very true