Does TEXTJOIN work in Excel 2019?

TEXTJOIN is available in Excel 2019 and Microsoft 365. Use CONCATENATE or & in older versions.

How do I skip blank cells when joining text?

TEXTJOIN has an ignore_empty argument. With CONCAT or &, filter blanks first or use IF on each cell.

Commas for CSV-style lists, " " for names, " | " for readable labels — pass it as the first argument in TEXTJOIN.

CONCAT vs TEXTJOIN

Compare CONCAT and TEXTJOIN for combining text in Excel, including delimiter control, blank handling, and readability.

Use CONCAT for simple joining without a delimiter. Use TEXTJOIN when you need separators, optional blank skipping, and cleaner multi-cell joins.

TEXTJOIN can insert commas, spaces, or custom delimiters automatically.
TEXTJOIN can ignore empty cells, which prevents double commas in address or name lists.

CONCAT is enough when you only need to append a few values with no separator logic.
CONCAT works in more environments when TEXTJOIN is unavailable.

Does TEXTJOIN work in Excel 2019? TEXTJOIN is available in Excel 2019 and Microsoft 365. Use CONCATENATE or & in older versions.
How do I skip blank cells when joining text? TEXTJOIN has an ignore_empty argument. With CONCAT or &, filter blanks first or use IF on each cell.
What delimiter should I use? Commas for CSV-style lists, " " for names, " | " for readable labels — pass it as the first argument in TEXTJOIN.

CONCAT (or legacy CONCATENATE): merges values with no delimiter — fine for codes and IDs.
TEXTJOIN: adds a delimiter (comma, space, line break) and can skip blank cells in one formula.
TEXTJOIN requires Excel 2019+ or Microsoft 365; CONCAT is available in Excel 2016+.
For full names from First + Last, TEXTJOIN with a space delimiter is usually cleaner.

Numbers merged as text may break downstream SUM — convert or keep numeric columns separate.
Very long TEXTJOIN results can hit the 32,767 character cell limit on huge lists.
Use TRIM on source columns before merging to avoid double spaces in exported labels.

Build both formulas side-by-side on a sample Table and compare results row by row.
Document which version each stakeholder uses before standardizing on the newer function.
Keep a migration log when replacing legacy formulas — note old and new syntax per column.

Verdict summary: Use CONCAT for simple joining without a delimiter. Use TEXTJOIN when you need separators, optional blank skipping, and cleaner multi-cell joins.
Recreate both formulas on ten sample rows and compare with EXACT or subtraction helper columns.
List which teammates still run Excel 2019 or Excel for the web before mandating the newer option.
Document migration date and owner when replacing legacy syntax in shared production models.
Related functions to review next: CONCAT, TEXTJOIN, CONCATENATE, LEFT, TRIM.
Keep legacy blocks stable during pilot — migrate one column or report section at a time until totals reconcile.

Publish the verdict internally: Use CONCAT for simple joining without a delimiter. Use TEXTJOIN when you need separators, optional blank skipping, and cleaner multi-cell joins.
Pilot on a copy of the production sheet with ten known test keys before mass migration.
Train Excel 2019 users on the legacy option until IT confirms Microsoft 365 desktop for all editors.
Add a changelog column documenting which rows still use the older function after partial migration.
Link new hires to both function pages and this comparison from your team wiki or onboarding doc.
Re-run reconciliation monthly for one quarter after rollout to catch edge cases early.