Check Sheet Logo
Check Sheet

CONCAT

The CONCAT formula in Google Sheets is used to combine two or more strings or cell values into a single string. It is most commonly used to join values from different cells or to create a custom message or label. The operator CONCAT can also be used in combination with other formulas to manipulate the joined values.

Usage

Use the CONCAT formula with the syntax shown below, it has 2 required parameters:

=CONCAT(value1, value2)
Parameters:
  1. value1 (required):
    The first value or cell reference to be joined.
  2. value2 (required):
    The second value or cell reference to be joined.

Examples

Here are a few example use cases that explain how to use the CONCAT formula in Google Sheets.

Joining First and Last Names

The CONCAT formula can be used to combine the first and last names of a list of people into a single cell. This is useful when creating labels or directories.

Creating a Custom Message

The CONCAT formula can also be used to create a custom message by combining static text with cell values. For example, to create a message that includes the name and date of an event.

Creating a Unique Identifier

The CONCAT formula can be used to create a unique identifier by joining together different cell values. For example, to create a unique ID for a list of orders by combining the customer name and order number.

Common Mistakes

CONCAT not working? Here are some common mistakes people make when using the CONCAT Google Sheets Formula:

Incorrect syntax

Make sure to include both values to concatenate between the parentheses, separated by a comma.

Using wrong data types

Make sure that value1 and value2 are of the same data type or can be converted to the same data type.

Missing quotation marks

If you are concatenating text, make sure to enclose each value in quotation marks.

Using unnecessary commas

Do not include a comma after the final value in the formula.

Not using CONCATENATE

If you are using an older version of Google Sheets, you may need to use the CONCATENATE function instead of CONCAT.

Related Formulas

The following functions are similar to CONCAT or are often used with it in a formula:

  • CONCATENATE

    The CONCATENATE function in Google Sheets is used to combine text strings from different cells or inputted directly in the formula. It takes one or more text strings as input and returns a single concatenated string. This function is commonly used to combine first and last names, or to merge data from multiple cells into a single cell.

  • JOIN

    The JOIN formula concatenates the elements of one or more arrays using a specified delimiter string. It is commonly used to combine text strings or to create comma-separated lists of values.

  • TEXTJOIN

    The TEXTJOIN formula concatenates (joins together) multiple text strings using a delimiter of your choice. This can be useful when combining lists, creating sentences, or formatting data for export. You can choose to ignore empty cells or include them as part of the output.

Learn More

You can learn more about the CONCAT Google Sheets function on Google Support.