Text
Excel 2019
◉ 44 views
=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.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Microsoft365.com
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Hover argument names in the table for details.
Output typeText
Popularity50 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =TEXTJOIN() 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 |
|---|---|---|---|
delimiter |
Any type | Required | A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text. |
ignore_empty |
Logical | Required | If TRUE, ignores empty cells. |
text1 |
Text | Required | Text item to be joined. A text string, or array of strings, such as a range of cells. |
text2 |
Text | Optional | Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
Currency |
A3 |
US Dollar |
A4 |
Australian Dollar |
A5 |
Chinese Yuan |
A6 |
Hong Kong Dollar |
A7 |
Israeli Shekel |
A8 |
South Korean Won |
A9 |
Russian Ruble |
A10 |
Formula: |
B10 |
=TEXTJOIN(", ", TRUE, A2:A8) |
A11 |
Result: |
A12 |
A's |
B12 |
B's |
A13 |
a1 |
B13 |
b1 |
A14 |
a2 |
B14 |
b2 |
A15 |
a4 |
B15 |
b4 |
A16 |
a5 |
B16 |
b5 |
A17 |
a6 |
B17 |
b6 |
A18 |
a7 |
B18 |
b7 |
A19 |
Formula: |
B19 |
=TEXTJOIN(", ", TRUE, A2:B8) |
A20 |
Result: |
A21 |
City |
B21 |
State |
C21 |
Postcode |
D21 |
Country |
A22 |
Tulsa |
B22 |
OK |
C22 |
74133 |
D22 |
US |
A23 |
Seattle |
B23 |
WA |
C23 |
98109 |
D23 |
US |
A24 |
Iselin |
B24 |
NJ |
C24 |
08830 |
D24 |
US |
A25 |
Fort Lauderdale |
B25 |
FL |
C25 |
33309 |
D25 |
US |
A26 |
Tempe |
B26 |
AZ |
C26 |
85285 |
D26 |
US |
A27 |
end |
A28 |
, |
B28 |
, |
C28 |
, |
D28 |
; |
A29 |
Formula: |
B29 |
=TEXTJOIN(A8:D8, TRUE, A2:D7) |
A30 |
Result: |
A31 |
Currency |
A32 |
US Dollar |
A33 |
Australian Dollar |
A34 |
Chinese Yuan |
A35 |
Hong Kong Dollar |
A36 |
Israeli Shekel |
A37 |
South Korean Won |
A38 |
Russian Ruble |
A39 |
Formula: |
B39 |
=TEXTJOIN(", ", TRUE, A2:A8) |
A40 |
Result: |
A41 |
A's |
B41 |
B's |
A42 |
a1 |
B42 |
b1 |
A43 |
a2 |
B43 |
b2 |
A44 |
a4 |
B44 |
b4 |
A45 |
a5 |
B45 |
b5 |
A46 |
a6 |
B46 |
b6 |
A47 |
a7 |
B47 |
b7 |
A48 |
Formula: |
B48 |
=TEXTJOIN(", ", TRUE, A2:B8) |
A49 |
Result: |
A50 |
City |
B50 |
State |
C50 |
Postcode |
D50 |
Country |
A51 |
Tulsa |
B51 |
OK |
C51 |
74133 |
D51 |
US |
A52 |
Seattle |
B52 |
WA |
C52 |
98109 |
D52 |
US |
A53 |
Iselin |
B53 |
NJ |
C53 |
08830 |
D53 |
US |
A54 |
Fort Lauderdale |
B54 |
FL |
C54 |
33309 |
D54 |
US |
A55 |
Tempe |
B55 |
AZ |
C55 |
85285 |
D55 |
US |
A56 |
end |
A57 |
, |
B57 |
, |
C57 |
, |
D57 |
; |
A58 |
Formula: |
B58 |
=TEXTJOIN(A8:D8, TRUE, A2:D7) |
A59 |
Result: |
Example 1
=TEXTJOIN(", ", TRUE, A2:A10)
Example 2
=TEXTJOIN("-", TRUE, A2, B2, C2)
§ Remarks
- If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.
⚠ Common Errors
#VALUE!
If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN 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!