SheetFX
≡
<< Go back to all functions

SPLIT

The SPLIT function in Google Sheets is a powerful tool to divide text around a specified character or string and distribute each fragment into separate cells in a row. Whether you're separating names, splitting addresses, or organizing data, the SPLIT function simplifies the task. Explore our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Parameters:

  • text: The text or range of cells to be divided.
  • delimiter: The character or string to use as the dividing point.
  • split_by_each: [Optional] Determines whether each character in the delimiter string is treated as a separate delimiter. By default, it is set to FALSE.
  • remove_empty_text: [Optional] Determines whether to remove empty substrings from the result. By default, it is set to TRUE.

Step-by-Step Tutorial

  1. Using SPLIT to divide text with a specific delimiter:

    • Example: =SPLIT("apple,banana,orange", ",")
    • Result: apple | banana | orange

  2. Using SPLIT with additional parameters:

    • Example: =SPLIT("apple,banana,,orange", ",", TRUE, TRUE)
    • Result: apple | banana | orange

Use Cases and Scenarios

  1. Data Organization: Split full names into first and last names.
  2. Address Formatting: Divide an address into street, city, state, and zip code.
  3. Text Manipulation: Extract specific parts from a text string.

Related Functions

  • JOIN: Combine multiple elements into a single string.
  • SUBSTITUTE: Replace specified text within a string with new text.

Related Articles