The issue with cross posting is that in the event someone goes out of there way to write up a solution it is super annoying to write the solution only to find out it is already solved by someone else. Now with the issue you are experiencing this seems like a relatively easy thing to fix.

It sounds to me that it is a text to columns issue meaning that the text to columns settings are causing the data to parse. Before pasting in the data run a text to columns on a sample set of data and remove ALL settings. After that is done try copying and pasting your data back in and I think it should work.

Thanks