In this case, you just need to change the delimiter in the function to the character (s) that separate.

How to divide on google sheets. Open a spreadsheet and put in. Click on the data menu. Select a cell and type ( =) select the dividend.

Select data from the top menu. This formula has two required parameters. Select the column with names and go to split names this time:

Here’s what you have to do to divide one column by another without remainder: Select all the cells you want to split or the whole column. Make sure the cells to the right don’t already have data in them.

Specify the number of cells in which to split the current cell and click ok. For the first example, the delimiter is “e”, so the result is one cell with all the text before the e’s in “sheetgo”, and one cell with all the text after the e’s. Whether you need to divide static integers or data from two cells or the entire contents of two columns, google sheets provides a couple of methods to help you calculate the quotient.

Fire up your browser, open up a google sheets document, and select all the cells you want to split up. Sign into google drive and open the document to split in half. Select split text to columns.

Fire up your browser, head to google sheets, and open a spreadsheet. Here’s how you do it. Type ( /) select the divisor lock and add two dollar signs ( $) before the column and row or press f4.