We can split a cell in google spreadsheet by highlighting the cell and unmerging it. This will automatically split the merged cells. This tutorial will teach us how to split cells into columns, Split text to columns and rows in Excel.
Figure 1a: Split cells in a spreadsheet
Figure 1b: Split text to columns
Figure 1c: Split text to rows
How to Split cells in Google sheets
- We will open a Google spreadsheet
Figure 2: Google Sheet
- We will highlight a section we want to merge on our worksheet
Figure 3: Highlighted cells
- We will now click on format in the taskbar, then select the merge option and click on merge all.
Figure 4: Merged cells
- We can split the cells by clicking on the portion of the spreadsheet we want to split, click on format, then select the merge option. We will click on unmerge cells
Figure 5: Unmerged cells
How to Split Text to Columns in Excel
When we have texts that we intend to split in a single column, e.g. first name and last name, we can split the text into a column by doing the following:
Figure 6: Inputted Text
- We will highlight Cells A2 to A4 and click on Data
- We will scroll down to select Split Text to Column
Figure 7: Split Text to Column
How to Split Text to Rows in Google sheets
- We can split text to rows only after splitting to columns.
Figure 8: Text
- We will highlight range A2:B4 and click on Cell C2 where our result will be returned
- We will right-click and select Paste Special
- We will click Paste Transpose
Figure 9: Split Text to rows
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.