Say I have a string of:
I would want to paste this every comma-separated value over 6 adjacent cells. How would I do it?
PS: There is no option for 'TAB' if your text is tab-separated, you can try 4 spaces as custom separator
You are able to paste CSV data as is into the spreadsheet and go to Data selecting Split text to columns... and even further specifying the delimiter:
Also, you can simply use keyboard shortcut combo:
LEFT ALT +
And as already mentioned
For a range/array it would be: