You will have to delete the entire formula result. So you can not remove or edit a part of the formula result. Similarly, if you have a column that has an address (where each address element is separated by a comma), you can use the comma as the delimiter to split the address into different columns. In this example, since we want to split the cell content before and after the space character, I have specified a space character (in double-quotes) as the second argument. The above SPLIT function takes the cell reference as the first argument and the delimiter as the second argument. You can easily do this using the below SPLIT formula (and copy for other cells in column B): = SPLIT ( A2, ' ' ) Suppose you have the dataset as shown below where you have the names and you want to split these names into first and last names. Google Sheets has a SPLIT function that’s well suited for… you guessed it… split the contents of the cell. How to Split Cells in Google Sheets: Split Cells into Columns Using the SPLIT function How to Split Cells in Google Sheets: Split Cells into Columns Using the SPLIT function.
