In this article we will show you how to split text in google sheets in different scenarios. We will show you how to use the split function and then how to split text to both columns and rows.
We can use the SPLIT function to split text in google sheets..
=SPLIT(cell, delimiter)
Where
Cell: the reference to the cell containing the string to split
Delimiter: also called separators, the special character in the data to use as markers for splitting it to columns; they are closed in double quotes
Note that this formula applies to only a single cell.
In this example, we identify the following inputs:
Cell: A2
Delimiter “ ” (space)
The formula becomes
=SPLIT(A2,” ”)
And we insert this to cell B2.
The output becomes:
You can learn more about this method here.
We will use the SPLIT and TRANSPOSE functions to achieve this.
=TRANSPOSE(SPLIT(cell, delimiter))
Where
Cell: the reference to the cell containing the string to split
Delimiter: the special character in the data to use as markers for splitting it to columns; they are closed in double quotes
Note that this formula applies to only a single cell.
In this example, we identify the following inputs:
Cell: A1
Delimiter “,”
The formula becomes
=TRANSPOSE(SPLIT(A1,”,”))
And we insert it in cell D1.
The output becomes:
Check this guide for more details.
The range should be a single column with several rows of entries. The adjacent columns should be blank.
The Data option is in the main menu at the top of the page. The Split text to columns option is near the end of the dropdown list.
Separators are special characters that mark where you can separate the string to its parts.
A small box where you can select the separator will appear. You can either choose Detect automatically or select it from the drop-down list.
The list includes commas, periods, semicolons, and spaces. We will select Comma for this example.
After selecting the separator, just click anywhere in the sheet to keep the changes.
Click here to lean more about splitting text to columns.
If you enjoyed this article, you might also like our article on how to split columns in Google Sheets or our article on how to split text to rows in Google Sheets.
If you want to learn how to send mass emails from Google Sheets, we also suggest checking out our detailed guide.
