Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
TEXTJOIN
The TEXTJOIN function combines the contents of cell ranges or strings with a specified delimiter between each value.
TEXTJOIN(delimiter, ignore-empty, string, string…)
delimiter: A string to add between combined values. delimiter can also be empty, or a reference to a string in another cell.
ignore-empty: A boolean TRUE or FALSE.
TRUE (1): If TRUE, empty cells aren’t included in the result.
FALSE (0): If FALSE, empty cells are included in the result.
string: Any value. Can also be a cell or a range of cells.
string…: Optionally include one or more additional values or cell references.
Notes
Including header cells can cause TEXTJOIN to return an error.
As an alternative to the TEXTJOIN function, you can use &, the concatenation operator.
To combine the contents of cells without a delimiter, you can also use CONCAT.
Examples |
|---|
Given A2=1, A3=2, A4=3, B2=A, B3=B, B4=C, and C2:C4 are empty: =TEXTJOIN(" ",TRUE,A,B) returns "1 2 3 A B C". =TEXTJOIN(A2,TRUE,B) returns "A1B1C". =TEXTJOIN(",",FALSE,A2:A4,C2:C4,B2:B4) returns "1,2,3,,,,A,B,C". |