Check out example codes for "google sheets paste comma delimited text into separate cells". It will help you in understanding the concepts better.

Code Example 1

# Process:
1. Open a Google Sheets spreadsheet
2. Paste the data you want to split into columns
3. Immediately after pasting, in the bottom right corner of your data, 
   click the Paste icon
4. Click Split text to columns. Your data will split into different 
5. To change the delimiter, click the Detect Automatically dropdown menu.

# Note, for whatever reason, Google Sheets doesn't have an option to
# split tab-delimited data...

Learn ReactJs, React Native from