Text
TEXTJOIN function
Join texts with a delimiter. TEXTJOIN works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) | Argument | Use |
|---|---|
delimiter | required |
ignore_empty | required |
text1 | required, repeatable |
text2 | optional, repeatable |
Example
Join the distinct regions into one text.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Status | Amount | Date |
| 2 | #1001 | Acme Ltd | North | Paid | 1200 | 2026-01-14 |
| 3 | #1002 | Blue Fox | South | Open | 450 | 2026-01-20 |
| 4 | #1003 | Acme Ltd | North | Paid | 980 | 2026-02-03 |
| 5 | #1004 | Cedar & Co | East | Overdue | 2300 | 2026-02-11 |
| 6 | #1005 | Blue Fox | South | Paid | 610 | 2026-03-02 |
| 7 | #1006 | Delta BV | West | Open | 1750 | 2026-03-09 |
| 8 | North, South, East, West |
Result computed by the Sheets formula engine.
On live data
In Sheets, TEXTJOIN sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
Try it in a free calculator
Box and whisker plot makerPaste your numbers to draw a box and whisker plot with the minimum, quartiles, median, maximum, IQR and outliers, each worked out by a spreadsheet formula you can copy..Find duplicates in a listPaste a list to flag every duplicate, count the distinct values and list the ones that repeat, with the COUNTIF and UNIQUE formulas that do it in any spreadsheet..
More text functions
CONCATJoin text stringsLEFTFirst characters of textLENString lengthLOWERLowercasePROPERCapitalize each wordSUBSTITUTEReplace textTEXTFormat a number or date as textTRIMRemove extra spacesARRAYTOTEXTValues of an array as one textASCFull-width characters to half-widthBAHTTEXTNumber as Thai baht textCHARCharacter for a code from 1 to 255
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.