When pasting sometimes you will have better luck if you click once on the cell before pasting, rather than clicking twice.
If your source data is such that you always end up with the values all in one cell separated by one space, then you can easily separate them into separate cells with a script.
- Copy-paste the script into Script Editor (in Applications > Utilities).
- Select the cell(s) with the values that you need to place in separate cells.
- Click the run button in Script Editor
- Click a cell once and command-v to paste.
This will place to values in a column. If you want them spread across columns then just change the first 'return' in the script to 'tab'.
SG
tell application "Numbers"
tell document 1's active sheet
tell (first table whose selection range's class is range)
tell selection range
set pasteStr to ""
repeat with c in cells
set v to c's value
set pasteStr to pasteStr & my findReplace(v, " ", return) & return
end repeat
end tell
end tell
end tell
end tell
set the clipboard topasteStr
display notification "Click a cell once and command-v to paste"
to findReplace(tt1, f, r)
set AppleScript'stext item delimiters to f
set lst to tt1's text items
set AppleScript'stext item delimiters to r
set tt2 to lst as string
set AppleScript'stext item delimiters to r
return tt2
end findReplace