Excel function · Changing text
CONCAT
Joins texts, cells and ranges into one text.
What it does
CONCAT puts its arguments one after the other with nothing in between. Add spaces or punctuation yourself, as texts in quotes. It replaces the older CONCATENATE and also accepts whole ranges.
Syntax
=CONCAT(text1, [text2], …)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- text
- The first text, cell or range to join. Add more arguments for the parts that follow.
Example
First and last names are in separate columns. How do you get the full name?
| A | B | C | |
|---|---|---|---|
| 1 | First name | Last name | Full name |
| 2 | Ana | Ruiz | Ana Ruiz |
The formula in C2:
=CONCAT(A2," ",B2)Result: Ana Ruiz
The formula joins three parts: Ana, a space in quotes, and Ruiz. Without the " " in the middle the result would be AnaRuiz.
Common mistakes
- Forgetting the space between parts, which runs the words together.
- Joining a whole range when you need a separator between items. Use
TEXTJOINfor that. - Expecting a number's formatting to carry over. 0.5 shown as 50% is joined as 0.5; format it with
TEXTfirst.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | CONCAT | , |
| Deutsch | TEXTKETTE | ; |
| Français | CONCAT | ; |
| Español (España) | CONCAT | ; |
| Español (México) | CONCAT | , |
| 日本語 | CONCAT | , |
| 한국어 | CONCAT | , |
| 繁體中文 | CONCAT | , |
| ไทย | CONCAT | , |
| ខ្មែរ | CONCAT | , |
| Tiếng Việt | CONCAT | ; |