BeginnerText
Syntax
=CONCAT(text1, [text2], ...)| Argument | What it means |
|---|---|
text1 | The first text or cell. |
text2, ... | More text or cells. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Team list (fictional)
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Name | Department | Salary | Start date | Rating |
| 2 | Amira Hassan | Finance | 9200 | 2019-03-04 | 4 |
| 3 | Ben Carter | Sales | 7800 | 2021-07-19 | 3 |
| 4 | Chen Wei | Sales | 8100 | 2020-01-13 | 5 |
| 5 | Dina Ali | HR | 7200 | 2022-09-01 | 4 |
| 6 | Emil Novak | Operations | 6900 | 2018-11-26 | 2 |
| 7 | Farah Khan | Finance | 10400 | 2016-05-09 | 5 |
| 8 | Gabriel Silva | Operations | 6500 | 2023-02-14 | 3 |
=A2&" - "&B2The & sign does the same job: name and department
Examples that need no data
=CONCAT("INV-",2025,"-",42)Build a reference
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use CONCAT at work
- Administration
Build a label from two columns.
Data: Stock levels (fictional)=A2&" "&B2 - HR
Make a name and team label.
Data: Team list (fictional)=CONCAT(A3," (",B3,")")
Common mistakes and tips
- CONCAT does not add spaces. Add them yourself: CONCAT(A1," ",B1).
- Older Excel uses CONCATENATE or the & sign.
Works in
CONCAT needs Excel 2019 or later. The & sign works in every version.
Related formulas
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.