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?
Google-sheets – How to paste a comma separated string over multiple cells in Google Sheets
google sheetsgoogle-sheets-arrayformulakeyboard shortcuts
Related Topic
- Google-sheets – Convert the data from comma-separated cells into repeated rows
- Google-sheets – Comma-separated values analysis and pivot tables in Google Spreadsheets
- Google-sheets – How to display =filter() results as a comma separated list
- Google-sheets – How to sum a column with cells that have multiple values separated by a comma
- Google-sheets – How to create comma and hyphen separated list of sequential numbers in Sheets
- Google-sheets – How to turn a list of comma separated values into an array
- Google-sheets – G sheet How to jump over no value cells with SUMIF function
Best Answer
You can paste it into a split function in a cell and it will break it apart into multiple cells for you: