google sheets paste comma delimited text into separate cells

Solutions on MaxInterview for google sheets paste comma delimited text into separate cells by the best coders in the world

showing results for - "google sheets paste comma delimited text into separate cells"
Jermaine
23 Mar 2019
1# Process:
21. Open a Google Sheets spreadsheet
32. Paste the data you want to split into columns
43. Immediately after pasting, in the bottom right corner of your data, 
5   click the Paste icon
64. Click Split text to columns. Your data will split into different 
7   columns.
85. To change the delimiter, click the Detect Automatically dropdown menu.
9
10# Note, for whatever reason, Google Sheets doesn't have an option to
11# split tab-delimited data...