Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Split Cells and Split Text to Columns and Rows in Google Spreadsheet

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.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc