Sometimes when I paste space delimited values from a text file into excel it automatically separates them into the correct columns. Other times I have to use the "Text to Columns" tool. I haven't been able to determine what allows for the super efficient behavior - seems to occur randomly to me - and all the files/data I copy and paste in is always formatted the same way (i.e. same number of spaces between the decimal values).
How do I get the super efficient auto formatting upon pasting to occur regularly or on demand?