Description
Use this function to join two or more text strings into one string. Supported in Chains. Can be used with CHILDREFS.
CONCATENATE is useful for combining text from multiple cells into one cell.
Syntax
CONCATENATE(text_1, […, text_254])
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
text_1 |
Yes | The first text string to be joined. | A text string, a cell reference, or a formula that results in text. |
text_2 |
No | The additional text strings to be joined. | A text string, a cell reference, or a formula that results in text. |
Example
Sample data
| A | B | |
|---|---|---|
1 |
First | Last |
2 |
John | Doe |
3 |
Jane | Smith |
4 |
Hello | World |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Combine a first and last name from two cells into one, with a space between them. | =CONCATENATE(A2, " ", B2) |
Joins "John" and "Doe" with a literal space in between. Result: John Doe |
| Combine a first and last name from two cells into one, with a space between them. | =CONCATENATE(A3, " ", B3) |
Joins "Jane" and "Smith" with a literal space in between. Result: Jane Smith |
| Combine two words from separate cells into a single phrase, with a space between them. | =CONCATENATE(A4, " ", B4) |
Joins "Hello" and "World" with a literal space in between. Result: Hello World |
| Combine two values from separate cells directly together, with no space or separator. | =CONCATENATE(A2, B2) |
Joins "John" and "Doe" with nothing in between, since CONCATENATE doesn't add spaces automatically. Result: JohnDoe |
Notes
- CONCATENATE can accept up to 255 arguments.
- CONCATENATE does not automatically add spaces between the text strings. You must include spaces as part of the text arguments if needed.
- Use the ampersand (&) operator as an alternative to CONCATENATE. For example:
=A2 & " " & B2.
Tips
- Use CONCATENATE to combine text from different cells when creating custom messages or labels.
- When using CONCATENATE, be mindful of text length limits, which may affect the result.