TEXTJOIN merges cell contents and puts a chosen delimiter between included values. It is useful for creating a label, list or export field. For cells Desk, blank, Chair, Lamp, blank, =TEXTJOIN(" | ",TRUE,A2:A6) has the expected result Desk | Chair | Lamp.

Join a range of text values with a delimiter, choosing whether to skip blank cells. First check whether the input needs to be treated as text so that leading zeroes, spaces or punctuation are not silently changed during import. Start with the sample table below, verify its result, and only then adapt your formula to production records.

=TEXTJOIN(delimiter, ignore-empty, string, string…)

The syntax and parameter order above are taken from Apple’s TEXTJOIN reference (consulted 2026-10-11). Arguments shown as … are optional extra values, not punctuation to type literally. No first-supported Numbers app version was established by the official reference.

Create a Numbers table named Items. Set column A to Text, then enter the values. Leave A3 and A6 genuinely empty (do not type the word “blank” or a space).

1. In a separate result cell in Items, enter =TEXTJOIN(" | ",TRUE,A2:A6).
2. The delimiter is the three-character string space–vertical-bar–space. The TRUE argument says to ignore empty cells.
3. Expected result: Desk | Chair | Lamp. Blank A3 and A6 contribute no text or extra separators.
4. Compare =TEXTJOIN(" | ",FALSE,A2:A4): expected Desk | | Chair. The empty A3 is retained as an empty position between delimiters.
5. Compare =TEXTJOIN("",TRUE,A2:A5): expected DeskChairLamp, because the delimiter is empty.

Use the same table and exact formulas to test the difference before combining real imported data.

Add a fixed status value to a dynamic list

For an export summary with a final marker, use

=TEXTJOIN(" / ",TRUE,A2:A6,"Ready")

Expected result: Desk / Chair / Lamp / Ready. The range supplies the visible items and the final literal text supplies the marker. A marker will still appear if no items are present; decide whether that is appropriate for your report.

For a per-row composite key, if A2 is Desk and B2 is Blue, =TEXTJOIN("-",TRUE,A2,B2) is expected to return Desk-Blue. An explicit key design is better than accidentally joining blanks without separators.

• Argument order: the first argument is the separator and the second is TRUE/FALSE. TEXTJOIN(TRUE," | ",A2:A6) is not the official order.
• Blank handling: FALSE keeps the position of genuinely empty cells; TRUE omits them. A text string containing spaces is not an empty cell. Formula-generated empty strings and imported missing values deserve a direct app test; Apple explicitly documents empty cells.
• Unexpected header inclusion: Apple’s reference cautions that including header cells can cause an error. Use an explicit data-only range (A2:A6), not the header row.
• A missing delimiter: "" means no separator. If you want readable punctuation, supply a string such as ", ".
• Locale parsing: if your system uses a comma decimal separator, change argument separators to semicolons while preserving the delimiter inside quotation marks.
• Moved table: a reference to a different Numbers table may need the table name and ::; choose the source cells in the formula editor.

Excel and Google Sheets have functions called TEXTJOIN with a comparable high-level purpose, but validate platform version, argument parsing and blank-string behavior before importing formulas. Apple Numbers distinguishes CONCAT (no automatic delimiter) from TEXTJOIN (one delimiter between included values). Numbers references can include Table Name::A2, unlike the default Excel Sheet!A2 syntax. Apple’s reference specifically warns about including table headers.

This page follows Apple’s English Formulas and Functions Help 15.4 documentation, checked 2026-10-11. That is a documentation version, not proof of the first Numbers release that supported this function. Apple describes its Functions Browser for Numbers on Mac, iPhone, iPad and iCloud.com; the cited function reference does not specify a separate minimum installed version for this function or certify that all device editions behave identically. Mac, iPhone, iPad and web execution were not tested here.

• In the example table, a formula placed in the same table can use A2, B2 or A2:A6. For another Numbers table, the explicit form can be Products::A2 or Sheet 2::Products::A2 where disambiguation is needed. Use the built-in reference picker to avoid errors.
• Apple’s English documentation separates arguments with commas. With a comma decimal separator configuration, Apple instructs you to use semicolons as function argument separators when typing by hand, such as =TEXTJOIN(" | ";TRUE;A2:A6). This does not alter punctuation inside quoted text.
• The examples are illustrative content, not screenshots and not proof of live application execution.

• TEXTAFTER: splitting a delimited value
• TEXTBETWEEN: retrieving a middle field

Internal related-guide URLs should be confirmed in the final site build; the source documentation is linked above.

• Apple Numbers — function documentation
• Apple Functions Overview
• Apple: Refer to cells in formulas
• Apple Formulas and Functions Help

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.