Text to Columns - Old question; New solution?

[ed9213]

Excel 2010 saves the Text to Columns parameters until Excel is closed. For example, if one checks the box near Comma, the next import or selection will automatically be delimited by comma, whether one wants it or not. Can this behavior be turned off? Most of the posts on this subject are quite old, so perhaps some recently discovered registry tweak (Using Windows 7 Pro 64-bit) or new revelation might turn this quite annoying feature off. Thanks.

 

[fhaider]

You can just paste-values. It will solve your problem

Short-cut key => Alt + E > S > V

 

[ed9213]

You can just paste-values. It will solve your problem

Short-cut key => Alt + E > S > V

fhaider, Thanks for your response. That combination doesn't seem to be valid in Excel 2010. Even so, I don't think I explained myself clearly. If I import data, like date and time data, 4/1/2014 11:45:00, I will first separate by delimiter /, then space, then :. I'll close the worksheet, but not Excel (because other workbooks are open). The next worksheet I try to manipulate will have remembered the : and automatically split my input on that delimiter. I would prefer if it required input each time. This "help" inserted by Microsoft isn't any help at all. If I could turn off that automatic splitting of data on the last-used filter, I would be a happier man. Thanks, again.

 

[shg]

You can't turn the behavior off to my knowledge, but you can reset it manually (untick all of the delimiters), or do the same thing via code.

 

[ed9213]

You can't turn the behavior off to my knowledge, but you can reset it manually (untick all of the delimiters), or do the same thing via code.

shg, Thanks for that suggestion. I found online someone's code for clearing the check boxes, but I couldn't find an additional piece that would clear those boxes every time a file was closed. So I can manually run it as a macro. If I could put that into the book.xlt or wherever that would make that piece of code run whenever a workbook is closed, even if Excel is not, my search would be complete.

 

[shg]

You could put it in Personal and assign a shortcut.