CONCATThe 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.
- How to use
- Examples of using
CONCATformula not working?
- Similar formulas to
CONCAT formula with the syntax shown below, it has 2 required parameters:
- value1 (required):
The first value or cell reference to be joined.
- value2 (required):
The second value or cell reference to be joined.
ExamplesHere are a few example use cases that explain how to use the
CONCATformula 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.
CONCATnot working? Here are some common mistakes people make when using the
CONCATGoogle Sheets Formula:
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.
The following functions are similar to
CONCAT or are often used with it in a formula:
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.
JOINformula 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.
TEXTJOINformula 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.
You can learn more about the
CONCAT Google Sheets function on Google Support.