Text to columns will not shut off.
 

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.

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?



In article ,
"Gerald Cornforth" <Gerald wrote:

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.

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Gerald Cornforth" <Gerald wrote in message
...
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

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



Ken Wright wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Gerald Cornforth" <Gerald wrote in message
...
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.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

--

Dave Peterson

LOL - Very true :-)

"Dave Peterson" wrote:

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



Ken Wright wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Gerald Cornforth" <Gerald wrote in message
...
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.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

--

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!)

Ken Wright wrote:

LOL - Very true :-)

"Dave Peterson" wrote:

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



Ken Wright wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Gerald Cornforth" <Gerald wrote in message
...
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.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004

--

Dave Peterson


--

Dave Peterson