Stop Text to Columns 2

[rnordquest]

I have been block copying text into cells successfully then something happened to my file. Now instead of dropping the whole sentence into a cell it does an automatic 'text to column' and spreads the sentence across cells, one word to a cell.

This has to be a global option of some sort. How do I change it back so all the text goes into one cell?

Roger

 

[cpretty]

rnordquest,

The text to columns works in an odd way. It would appear that the last time you used text to columns in that session of excel use, sets the default settings for the rest of that session.

What this means is that if you have used the text to columns to parse something using spaces, then spaces is the default delimiter. When you then cut and paste the 'microsoft helpful' function recognises this as space delimited and consequently screws up your work. The way to get out of it is to do a text to columns using characters you never would paste in, thereby setting up new settings.

Hope this helps,

Craig

 

[brengine]

This is my work around, select the paste-to cell, hit any character key, then backspace, then ctrl+v. Work nice if you want to loose all the formatting on the copied data as well.

Ken