SheetFX
≡
<< Go back to all functions

CONCAT

The CONCAT function in Google Sheets is used to concatenate or combine two values into a single string. It is equivalent to using the & operator. With CONCAT, you can easily merge text from different cells, add prefixes or suffixes to values, or create custom strings.

Function Syntax and Parameters

Syntax: CONCAT(value1, value2)

Parameters:

  • value1: The first value or cell to concatenate.
  • value2: The second value or cell to concatenate.

Step-by-Step Tutorial

  1. Using CONCAT with values:

    • Example: =CONCAT("Hello", "World")
    • Result: HelloWorld

  2. Using CONCAT with cell references:

    • Example: If cell A1 contains the value Hello and cell B1 contains the value World, then =CONCAT(A1, B1) will return HelloWorld.

Use Cases and Scenarios

  1. Merging Text: Combine text from multiple cells into a single string.
  2. Adding Prefixes or Suffixes: Concatenate additional text before or after values.
  3. Creating Custom Strings: Build custom strings by concatenating different pieces of text.

Related Functions

  • & Operator: The & operator can be used as an alternative to the CONCAT function.

Related Articles