How To Split Cells In Google Sheets? 2 Simple Methods

Can you how to split cells in google sheets? While working in Google Sheets, you may need to divide the data into two or more cells. In this case, you can use the split function that comes in handy for you. Today, we will discuss how to split the content of a cell in Google sheets. Here, I have mentioned two methods that will help to separate them into multiple rows or columns. So, let us now study how to split cells in google sheets by using these two simple methods.

How To Split Cells In Google Sheets?

You can split cells in google sheets by using any of the two methods.

  1. By using the split formula
  2. By using the split text function

Both these methods will help you to divide your data into a cell or multiple cells. You can continue reading to learn more about how to use this function to split cells in google sheets.

By Using The SPLIT Formula

This is the easiest way if you want to learn how to split cells in google sheets. Below I have mentioned down the list of instructions for this method.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. In the formula bar, type SPLIT (A2,” “) formula.
  4. Press the Enter key on your keyboard.
  5. Done

Here, A1 is the cell you want to split and the delimiter (“ “) is the space.

Below I have inserted two images where you will see the results by using this formula.

By Using Split Text Function

You can follow these instructions to use a split text function.

  1. Open the google spreadsheets you want to edit.
  2. Select the cells whose data you want to split.
  3. Click on the Data menu on the toolbar.
  4. Select the Split text to columns option.
  5. Select the comma or space option in the separator dialog box.
  6. Click on the OK button to save.

This will split your data into different columns. In some cases, you can select both the comma and space options in the separator dialog box. Below I have given some images that will help you to understand much better.

Split Cells Horizontally In Google Sheets

Do you know how to split a cell horizontally in your google sheets? Here, you can split cells into rows by using the split formula in google sheets.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. Click on the Data menu on the toolbar.
  4. Select the Split text to columns option.
  5. Select the comma or space option in the separator dialog box.
  6. Click on the Ok button to save.

Split Cells Vertically In Google Sheets

Many among us do not know how to split a cell vertically in the google sheets. In this case, you can use a shortcut key. Below I have listed down some instructions that you need to follow.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. Now, type the TRANSPOSE (SPLIT (A1,” “)) formula in a blank cell.
  4. Press the Enter key on your keyboard.
  5. Done

Read Also: What Is ICYDK? How To Use It?

FAQ

How Do I Split A Cell Vertically In Google Sheets?

You can split a cell vertically in google sheets by using these steps.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. Now, type the TRANSPOSE (SPLIT (A1,” “)) formula in a blank cell.
  4. Press the Enter key on your keyboard.
  5. Done

How Do You Use Split Function In Google Sheets?

You can use the split function in google sheets by using the following instructions.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. Click on the Data menu on the toolbar.
  4. Select the Split text to columns option.
  5. Select the comma or space option in the Separator dialog box.
  6. Click on the Ok button to save.

How Do You Split Cells In Google Docs?

Follow these steps if you want to split cells in google docs.

  1. Open the google spreadsheet you want to edit.
  2. Double-click on the cells you want to split.
  3. Select the Split Cells option from the list.
  4. Enter the number of cells in which you want to split the current cells.
  5. Click on the OK button to save.
  6. Done

How Do I Split Text Into Rows In Google Sheets?

You can split the text into rows by using the below-given split formula in google sheets.

  1. Open the google spreadsheet you want to edit.
  2. Select the cells whose data you want to split.
  3. Now, type the TRANSPOSE (SPLIT (A1,” “)) formula in a blank cell.
  4. Press the Enter key on your keyboard.
  5. Done

Read Also: TRIMs Full Form & Meaning

Conclusion

In my above article, we have studied two ways to split cells in google sheets. Here, I have taught you to use the split formula and split text to column shortcuts in detail. Both these functions will help you to split the text into different rows and columns. The fastest way to split Google sheets is by using the Split text to column shortcut. Make sure you pick a separator to split your data into fragments. Thus, I assume that you have now understood how to split cells in google sheets by reading the guide.

Similar Articles

Most Popular