Say I have a string of: l,f,x,a,s,f
I would want to paste this every comma-separated value over 6 adjacent cells. How would I do it?
Say I have a string of: l,f,x,a,s,f
I would want to paste this every comma-separated value over 6 adjacent cells. How would I do it?
You can paste it into a split function in a cell and it will break it apart into multiple cells for you:
=SPLIT("l,f,x,a,s,f", ",")
From https://support.google.com/docs/answer/6325535?hl=en :
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
+ D
+ E
And as already mentioned SPLIT
formula:
=SPLIT("l,f,x,a,s,f"; ",")
=SPLIT(A1; ",")
For a range/array it would be:
=ARRAYFORMULA(IFERROR(SPLIT(A1:A; ",")))