Paste comma separated content into different cells in google sheets

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.

How do I paste one thing into multiple cells in Google Sheets?

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

enter image description here