How do I use CONCAT in Excel?
Use CONCAT when you want to combine multiple text values. Enter Text 1, Text 2 in that order, then add optional arguments when needed.
Excel Function
CONCAT
Concatenates multiple text values.
CONCAT(text1, [text2], ...)Arguments
text1
RequiredSpecify a reference range. You can drag or click start/end cells.
text2
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use CONCAT to return the result with these settings (Text 1: B2 (Name in column B), Text 2: C2 (Email in column C)). You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | E003 | Ken Sato | k.sato@example.com | 2450 | 2450 |
| 5 | E004 | Aya Takahashi | a.takahashi@example.com | 3000 | 3000 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=CONCAT(B2, C2)Result
Taro Tanakat.tanaka@example.com
Practice This Function
CONCAT FAQ
Where can I practice CONCAT?
Use the "Start Function Practice" button to jump straight into CONCAT drills.
What arguments does CONCAT use?
The main arguments are Text 1, Text 2. Start with the required ones, then add optional arguments if needed.