CONCATENATE function in Excel
CONCATENATE joins text items (legacy).
Syntax
=CONCATENATE(text1, [text2], …)
| Argument | Required? | What it is |
|---|---|---|
| text1 | Required | The first text, cell or range to join. |
| text2, … | Optional | More text to join (optional). |
Practise CONCATENATE in a live spreadsheet
There is no dedicated lesson yet. Browse all lessons.
Related text functions
- LENReturns the number of characters.
- LEFTReturns characters from the start of the text.
- RIGHTReturns characters from the end of the text.
- MIDReturns characters from the middle of the text.
- FINDCase-sensitive position of text within text.
- SEARCHCase-insensitive position of text; supports wildcards.
- CONCATJoins text from cells and ranges.
- TEXTJOINJoins text with a delimiter.