Here is a good post that accurately resets what Excel parses on when you paste text. I have known for a long long time, that the LAST text-to-columns settings is what is used when one pastes data into excel, but I thought I would see (I finally snapped for the last time) what other people did. Well, it is a macro of what I always do by hand – a fake text to columns that sets things in prep for the real one. My issues is that I have all sorts of macros that could set this here or there depending on the last one I ran. Thanks for the post!

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters/