I would like to be able to copy some data from a text file and paste it into Excel 2010. The data in question is a small number of single digits and I would like each one to go into a separate column.

To test this, I created a simple test string, such as “1 2 3 4”, but when I copied/pasted it into Excel, all of the characters went into one cell. I tried replacing the spaces with tabs and commas, but that did not help. I checked Control Panel->Regional Settings->Additional Settings and see that List Separator is a comma.

I am not sure what to try next. Any suggestions?