SheetFX
≡
<< Go back to all functions

JOIN

The JOIN function in Google Sheets is a powerful tool to concatenate the elements of one or more one-dimensional arrays using a specified delimiter. It allows you to combine text or values from multiple cells into a single cell. Learn how to use the JOIN function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: JOIN(delimiter, value_or_array1, [value_or_array2, ...])

Parameters:

  • delimiter: The delimiter used to separate the elements.
  • value_or_array1: The first value or array to join.
  • value_or_array2, ...: [Optional] Additional values or arrays to join.

Step-by-Step Tutorial

  1. Using JOIN with individual values:

    • Example: =JOIN("-", "Google", "Sheets")
    • Result: Google-Sheets

  2. Using JOIN with one-dimensional arrays:

    • Example: If A1:A3 has the values 1, 2, 3, then =JOIN("-", A1:A3) will return 1-2-3.

  3. Using JOIN with a mix of values and arrays:

    • Example: If A1:A3 has the values 1, 2, 3, and B1:B3 has the values Google, Sheets, Functions, then =JOIN("-", A1:A3, B1:B3) will return 1-2-3-Google-Sheets-Functions.

Use Cases and Scenarios

  1. Data Manipulation: Combine data from different cells into a single cell.
  2. CSV Generation: Build comma-separated value (CSV) strings from arrays.
  3. Text Formatting: Concatenate text with specific delimiters.

Related Functions

  • TEXTJOIN: Join text strings from a range into a single string, with a specified delimiter.
  • CONCATENATE: Join two or more text strings into one string.

Related Articles