SPLIT Function: Split Text in Google Sheets by Specified Delimiters

スポンサーリンク
スポンサーリンク

About the SPLIT Function

Overview of SPLIT

Split Text Using DelimitersGoogle Sheets Function

=SPLIT( text, delimiter, [split_by_each], [remove_empty_text] )

Summary The SPLIT function divides a string into separate components based on a specified delimiter and places each part into a separate cell.

  • Efficiently splits strings based on a delimiter.
  • Useful for organizing and reformatting data.
  • Ideal for processing CSV data or analyzing complex text strings.

When to Use SPLIT

  • When splitting text into components based on a specific delimiter.
  • To process or analyze text data effectively.
  • When multiple values are entered in a single cell, and you need to separate them for better organization.

How to Use SPLIT

The following example demonstrates the basic usage of the SPLIT function.

  A B C D
1 Data Split 1 Split 2 Split 3
2 John,Emily,Michael =SPLIT(A2, “,”)

Results

  • The text in cell A2, “John,Emily,Michael,” is split based on the delimiter “,”.
  • Cell B2 contains “John,” cell C2 contains “Emily,” and cell D2 contains “Michael.”

Advanced Usage of SPLIT

Below are examples demonstrating advanced use cases for the SPLIT function:

  A B C D
1 Data Item 1 Item 2 Item 3
2 apple;orange;banana =SPLIT(A2, “;”)

Results

  • The text in cell A2, “apple;orange;banana,” is split based on the delimiter “;.”
  • Cell B2 contains “apple,” cell C2 contains “orange,” and cell D2 contains “banana.”

Points to Note

  • If the delimiter is not found in the text, the entire string remains in one cell.
  • Only one delimiter can be specified at a time.
  • If spaces are used as the delimiter, multiple consecutive spaces are treated as a single delimiter when “split_by_each” is set to TRUE.

Conclusion

  • The SPLIT function is a convenient tool for splitting strings by delimiters and organizing data.
  • It is highly effective for processing and analyzing text data.
  • Its simplicity makes it ideal for handling complex text processing tasks.