Splitting and Merging Cell Data in Google Spreadsheets

Split Text to Columns

You can split clearly defined data, like text separated by commas, into several columns using "Split Text to Columns".

1. Select the cells you want to split.
2. At the top, click Data > Split text to columns.
3. To change which character that is used to split the data, next to "Separator" at the bottom of the list, click the dropdown menu.
4. To fix how your columns spread out after you split your text, click the menu next to "Separator" > Detect automatically.

Merge Data from two or more cells into one cell: Concatenate

You can use the concatenate formula to combine data from multiple cells into one cell.

1. In a column next to the columns you want to combine, type =CONCATENATE(
2. Click on the first cell with the information you want to combine, then type in a comma, then click on the second cell you want to combine (and so on).
3. A space between quotes will give you a space ," ",  
4. If you want to add text, put it in quotations.
5. Close with parenthesis

Video explanation on how to use the concatenate formula:

Thank you to Vanessa G. for this video.

For more information on Google Sheets functions and formulas, click HERE.