Table of Contents
The SPLIT function in Google Sheets allows users to easily separate data into multiple columns or rows. This function can be useful when dealing with large datasets or when organizing data in a specific way. By specifying a delimiter, the SPLIT function will divide the data in a selected cell or range into separate columns or rows, making it easier to work with and analyze. This feature is particularly helpful for users who need to quickly and accurately organize and manipulate data in their Google Sheets documents.
SPLIT function
Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
Examples
Make a copy
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdElfUHBJeXFPZlctRGxpc3N3Z2M2T0E&output=html” width=”500″]
Sample Usage
SPLIT("1,2,3", ",")
SPLIT("Alas, poor Yorick"," ")
SPLIT(A1, ",")
Syntax
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
text– The text to divide.delimiter– The character or characters to use to splittext.- By default, each character in
delimiteris considered individually, e.g. ifdelimiteris"the", thentextis divided around the characters"t","h", and"e". Setsplit_by_eachtoFALSEto turn off this behavior.
- By default, each character in
split_by_each– [ OPTIONAL –TRUEby default ] – Whether or not to dividetextaround each character contained indelimiter.remove_empty_text– [ OPTIONAL –TRUEby default ] – Whether or not to remove empty text messages from the split results. The default behavior is to treat consecutive delimiters as one (ifTRUE). IfFALSE, empty cells values are added between consecutive delimiters.
Notes
- Note that the character or characters to split the string around will not be contained in the result themselves.
See Also
CONCATENATE: Appends strings to one another.
Cite this article
stats writer (2024). How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-split-function-in-google-sheets-to-separate-data-into-multiple-columns-or-rows/
stats writer. "How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-split-function-in-google-sheets-to-separate-data-into-multiple-columns-or-rows/.
stats writer. "How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-split-function-in-google-sheets-to-separate-data-into-multiple-columns-or-rows/.
stats writer (2024) 'How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-split-function-in-google-sheets-to-separate-data-into-multiple-columns-or-rows/.
[1] stats writer, "How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the SPLIT function in Google Sheets to separate data into multiple columns or rows?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.