Know The Methods To Split Cells In Google Sheet

split cells in google sheet

You occasionally need to split a column into two or more new columns when you’re working on a data set. For example, if you imported a database with people’s first and last names in one cell, but you need to separate the names into two cells then you can use the SPLIT function that is available in the spreadsheet module that comes with Google Docs. You can unmerge the cells if they have been previously merged with the unmerge button on the toolbar.

Technographx has brought this article to show you how you can split cells in google sheet. Let us have a look at the different methods.

 

1) You Can Use SPLIT

 

split cells in google sheet

Source: i.ytimg.com

First of all, open the Google Docs spreadsheet containing the column you want to split and then you have to right-click the column’s title, which contains the letter for that column. Now, click “Insert 1 Right.” You have to repeat this process for the number of columns into which you want to split the cell. For example, if you want to split the column into three new columns then you have to click three times.

Also Read:- Excellent Advantages of Microsoft Internet Explorer Even Today

2) Type The Code

split cells in google sheet

Source: wikihow.com

You have to type the code into the cell to the right of the cell at the top of your original column for identifying the cell at the top of the column you’re splitting and also the character at which you want the split to begin. Now, you have to replace “A1” in the code with the cell number at the top of the column to split and replace “x” with the character, such as space. For example, for splitting the first and last name, type ” ” (a space enclosed in quotes) as this splits the cell at the space between the two names.

=SPLIT(A1, “x”)

Also many users have reported is the Problem with wireless adapter or access point error message and so here we have brought the solution.

So now we hope that you have got the idea of how to split the cells in google sheets and can do it for yourself too.