Home › Functions › Text › =CONCAT()
Text Excel 2019 ◉ 5 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
Share:

⬇ 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)
📥 Download CONCAT.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
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

اتصال ستون‌های B و C به‌صورت کلی =CONCAT(B:B, C:C)
اتصال محدودهٔ ‎B2:C8‎ =CONCAT(B2:C8)
ساخت جمله با اتصال داده‌های ستون A و متن‌های ثابت =CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")
اتصال سه بخش: رشتهٔ سلول B2، یک فاصله و مقدار سلول C2 =CONCAT(B2," ", C2)
اتصال سه بخش: مقدار C2، ویرگول و فاصله، و مقدار B2 =CONCAT(C2, ", ", B2)
اتصال سه بخش: مقدار B3، رشتهٔ ‎" & "‎ و مقدار C3 =CONCAT(B3," & ", C3)
اتصال همان موارد مثال قبل اما با عملگر محاسباتی ‎&‎ به‌جای تابع CONCAT =B3 & " & " & C3

✦ 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

⇄ Related Functions

=TEXT() The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. =CONCATENATE() Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one. =TEXTJOIN() The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

💬 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!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.