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 |
|---|---|
| First | Last |
| John | Doe |
| Jane | Smith |
| Hello | World |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=CONCATENATE(A2, " ", B2) |
Combines "John" and "Doe" with a space in between. | John Doe |
=CONCATENATE(A3, " ", B3) |
Combines "Jane" and "Smith" with a space in between. | Jane Smith |
=CONCATENATE(A4, " ", B4) |
Combines "Hello" and "World" with a space in between. | Hello World |
=CONCATENATE(A2, B2) |
Combines "John" and "Doe" without a space in between. | 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.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER