How to split text in Excel and Google Sheets | Zapier (2024)

FAQs

How to split text in Excel and Google Sheets | Zapier? ›

In Google Docs, you can insert a table, right-click a cell, select "Split cell", specify into how many columns (and / or rows) you want to subdivide the cell, and click "Split" to subdivide a cell.

In Google Docs, you can insert a table, right-click a cell, select "Split cell", specify into how many columns (and / or rows) you want to subdivide the cell, and click "Split" to subdivide a cell.

The SPLIT function in Google Sheets is used to divide a text string (or value) around a given delimiter, and output the separate pieces into their own cells.

Select the cells you want to split: product names in column C for me. Then go Data > Split text to columns: A floating pane will appear at the bottom of your sheet: It lets you select one of the most commonly used separators: comma, semicolon, period, or space.

Select the range of cells containing the names (in this case, F3:F18). Next, click on the Data menu and select Split text to columns from the dropdown list. Choose a separator to split the text, or let Google Sheets detect one automatically. You can also use a custom separator to split your cells.

To split a text string into rows and columns at a time, define both delimiters in your TEXTSPLIT formula. For example, to split the text string in A2 across columns and rows, we supply: The equal sign ("=") for col_delimiter. A comma and a space (", ") for row_delimiter.

Select the text you want to separate. Navigate to the “Data” tab → “Split text into columns”. Select the proper separator from a pull-down list → Left-click or choose “Custom” → input a custom separator → press the “Enter” key.

Google Sheets split text to columns: a shortcut

The fastest way to divide data in a cell or multiple cells is to press Alt+a,e. It will work if Compatible keyboard shortcuts are enabled.

What is a slicer in Google Sheets? ›

In Google Sheets, slicers are user-friendly, interactive objects that allow users to filter data within charts, tables, and pivot tables.

Split one single row to multiple rows (one column) by Paste Transpose feature. Normally we can copy the single row and then apply the Paste Transpose feature to convert this single row to multiple rows (one column) in Excel.