Text to Col. & Windows 7

[Burrgogi]

Running Win 7 Pro and Office 2007.

The text to columns in Excel 2007 seems to have a "intuitive" feature built in. Last year I upgraded from XP to Win7. One day I was working with some text in Notepad. Copied/pasted into Excel, clicked on the 'Text to columns' button. Later on in the day, I had another block of text in Notepad that I needed to manipulate. Copied & pasted again into Excel. Except this time, Excel "guessed" that I wanted split it up again and it automatically did the text to columns for me! Cool. Never did that for me the whole time I was using 2007 version under XP.

While this is a great feature, not every block of text that I copy & paste into Excel is going to require the text to columns.

So the question is how do I get it to stop doing that?

 

[Burrgogi]

Anyone?

 

[VoG]

Click in any cell with a value, Text to Columns, tick Delimited, click Next, untick everything, click Cancel.

 

[Burrgogi]

Click in any cell with a value, Text to Columns, tick Delimited, click Next, untick everything, click Cancel.

C'est ca! Merci beaucoup VoG.