TEXTJOIN Function in Excel: Syntax, Examples and Free Practice
TEXTJOIN is an Excel Text function. Joins text together with a chosen separator between each piece.
TEXTJOIN syntax
Arguments
delimiter: The character used to separate valuesignore_empty: Whether to skip empty cells when joining texttext1: The first piece of text
When to use TEXTJOIN
TEXTJOIN is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice TEXTJOIN online, free
Open the live Excel-style spreadsheet and try TEXTJOIN yourself. No Excel install or sign-up needed to start.
Practice TEXTJOIN now →Learn more
Read the tutorial: How to use TEXTJOIN.
More Text functions
Frequently asked questions
What does the TEXTJOIN function do in Excel?
Joins text together with a chosen separator between each piece.
What is the syntax of TEXTJOIN in Excel?
The syntax is =TEXTJOIN(delimiter, ignore_empty, text1, ...). delimiter: The character used to separate values; ignore_empty: Whether to skip empty cells when joining text; text1: The first piece of text.
Where can I practice TEXTJOIN online for free?
Open the free live spreadsheet on Cellgrids and try TEXTJOIN yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts