Google Sheets

How to Split Cells in Google Sheets

How to Split Cells in Google Sheets

There are a few different ways to split cells in Google Sheets. One way is to use the split function. To do this, type "=SPLIT(A1,B1)" into a cell where you want the result to appear, and then press enter. This will split the contents of A1 and B1 into two separate cells.

Another way to split cells is to use the VLOOKUP function. To do this, type "=VLOOKUP(A1,B1:C1,2,FALSE)" into a cell where you want the result to appear, and then press enter. This will split the contents of A1 into two separate cells, based on the value in B1. If B1 is blank, the contents of A1 will be split into two cells based on the value in C1.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.