Menu
Say I have the string "1,2,3,4". Is it possible to paste that string into Google Spreadsheets in such a way that each of the comma-separated values goes into a different cell to the right of the selected one? This is what the spreadsheet would look like after pasting.
708
asked Jan 25 '18 21:01
Select the first range then, holding down the CTRL key, select the second range. Then copy both ranges using CTRL + C or in the Menu, select Edit > Copy. Select the destination location and the press CTRL + V or, in the Menu, select Edit > Paste.
Since the file is a CSV. Ensure it is saved with the .CSV extension and upload the file to google sheets.
You also have the option of opening it with Microsoft excel and then pasting the cell formatted text into the google sheet.
Also You can paste the comma separated values into the google sheet and then click the paste icon that appears below the cell and select the 'Split text into columns' Option
69
answered Nov 11 '22 04:11
Enter into the spreadsheet
=SPLIT("1,2,3,4", ",")
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With