I have tried Data tab> From text> which takes me through a Text Wizard. Where as before one cell would have been able to contain many words, it seems now as though each cell is only able to contain one word, so it splits the content of what would normally be in one cell, over many cells, making some rows of data spread out over up to 100 columns! When I paste the data, the content of each row seems to split over many columns. Although I have been successfully copying and pasting CSV files into excel for some time now, recently, they have begun to behave in an odd way.
I am using Excel for Mac 2016 on macOS Sierra software.
