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