Text
Excel 2019
◉ 6 views
=CONCAT()
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=CONCAT(text1, [text2],…)
Hover argument names in the table for details.
Output typeText
Popularity50 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =CONCAT() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
text1 |
Any type | Required | Text item to be joined. A string, or array of strings, such as a range of cells. |
text2 |
Any type | Optional | Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
B2 |
a1 |
C2 |
b1 |
B3 |
a2 |
C3 |
b2 |
B4 |
a4 |
C4 |
b4 |
B5 |
a5 |
C5 |
b5 |
B6 |
a6 |
C6 |
b6 |
B7 |
a7 |
C7 |
b7 |
B8 |
a1 |
C8 |
b1 |
B9 |
a2 |
C9 |
b2 |
B10 |
a4 |
C10 |
b4 |
B11 |
a5 |
C11 |
b5 |
B12 |
a6 |
C12 |
b6 |
B13 |
a7 |
C13 |
b7 |
A14 |
brook trout |
B14 |
Andreas |
C14 |
Hauser |
A15 |
species |
B15 |
Fourth |
C15 |
Pine |
A16 |
32 |
B17 |
a1 |
C17 |
b1 |
B18 |
a2 |
C18 |
b2 |
B19 |
a4 |
C19 |
b4 |
B20 |
a5 |
C20 |
b5 |
B21 |
a6 |
C21 |
b6 |
B22 |
a7 |
C22 |
b7 |
B23 |
a1 |
C23 |
b1 |
B24 |
a2 |
C24 |
b2 |
B25 |
a4 |
C25 |
b4 |
B26 |
a5 |
C26 |
b5 |
B27 |
a6 |
C27 |
b6 |
B28 |
a7 |
C28 |
b7 |
A29 |
brook trout |
B29 |
Andreas |
C29 |
Hauser |
A30 |
species |
B30 |
Fourth |
C30 |
Pine |
A31 |
32 |
Example 1
=CONCAT(B:B, C:C)
Example 2
=CONCAT(B2:C8)
Result:
a1b1a2b2a4b4a5b5a6b6a7b7
Creates a sentence by joining the data in column A with other text.
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")
Result:
Stream population for brook trout species is 32/mile.
Joins three things: the string in cell B2, a space character, and the value in cell C2.
=CONCAT(B2," ", C2)
Result:
Andreas Hauser
Joins three things: the string in cell C2, a string with a comma and a space character, and the value in cell B2.
=CONCAT(C2, ", ", B2)
Result:
Hauser, Andreas
Joins three things: the string in cell B3, a string consisting of a space with ampersand and another space, and the value in cell C3.
=CONCAT(B3," & ", C3)
Result:
Fourth & Pine
Joins the same items as the previous example, but by using the ampersand (&) calculation operator instead of the CONCAT function.
=B3 & " & " & C3
Result:
Fourth & Pine
§ Remarks
- If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.
✦ Tips
- To include delimiters (such as spacing or ampersands (&)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function.
⚠ Common Errors
#VALUE!
If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.
Fix: Reduce the number of text strings
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!