Copy and paste issue from Excel to Keynote table I'm having a big issue when copying from multiple Excel cells/rows and then pasting into a Keynote/Numbers table. When I select multiple cells in Excel with named content such as 'David goes to the gym' and then paste into a Keynote/Numbers cell it stretches the content across 5 separate cells as opposed to keeping it in one cell. 

I have absolutely no idea why this is happening.. I've reinstalled office365 but this hasn't changed anything.

Anyone any ideas on this ?
Your delimiter in numbers is set to a 'space', so it reads spaces in the sentence as being cell delimiter. Hence, each word goes into a separate cell. You need to change the delimiter to a comma or a tab. Then only values separated this chacter will fill new cells. To change delimiter (taken from question):

In Numbers you can use any separator when importing csv tables.
On the format sidebar, in the table tab, look for adjust Import settings. Inside it you have delimited options where you can even use custom delimiters