Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > How to Use the TEXTJOIN Excel Function? 3 Easy Examples

How to Use the TEXTJOIN Excel Function? 3 Easy Examples

(Note: The TEXTJOIN Excel function is suitable for Excel 2019 and Office 365 versions) 

TEXTJOIN Excel Function: A Summary

The TEXTJOIN Excel function, as the name suggests, joins two or more text strings into a single output string. It is not that different from the CONCAT function, except TEXTJOIN concatenates by default by including delimiters. 

TEXTJOIN Excel vs CONCAT
TEXTJOIN Excel vs CONCAT

Its main purpose is to join two or more text values with a specific delimiter. It will return the concatenated text string, along with the specified delimiter as the output. 

In this short guide, you’ll learn:

  • TEXTJOIN Syntax and Arguments
  • TEXTJOIN Excel Examples
    • Use TEXTJOIN to Combine Names
    • Use TEXTJOIN to Concatenate a Range
    • How to keep Source Formatting in TEXTJOIN?
  • Things to Keep in Mind about TEXTJOIN

Related:

The FORMULATEXT Excel Function – 2 Best Examples

The Excel CHOOSE Function – 4 Best Uses

How to Autofit Excel Cells? 3 Best Methods

TEXTJOIN Syntax and Arguments

The TEXTJOIN formula has the following syntax:

TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...text_n])

A delimiter is any string or character that separates each text value of the concatenated string. Usually, this will be a comma, a space, or a hyphen. But, in some cases, it can even be as long as a phrase. For example, space is the delimiter in the name string “Microsoft Office”. Hyphen is the delimiter in the string “Alpha-Bravo-Delta”. 

Please keep in mind that you have to insert the delimiter within double-quotes. For example, to join text in cells A2 and B2 with a comma, use TEXTJOIN(“,”,TRUE,A2,B2). To use no delimiter, add a double-quote with no space i.e “”. 

Set ignore_empty to TRUE if you want to ignore empty cells while joining text. If you want to include empty cells in the concatenations, set it to FALSE. Instead of using the BOOLEAN TRUE or FALSE, you can also use the binary equivalent ‘1’ or ‘0’. 

text1, text2, ….. text_n is the list of all the cells that contain the text strings you want to join. The maximum number of strings that can be joined using TEXTJOIN is 252. 

Also Read:

How to Unmerge Cells in Excel? 3 Best Methods

How to Add Subscript in Excel? (6 Best Methods)

How to Apply the Accounting Number Format in Excel? (3 Best methods)

TEXTJOIN Excel Examples

Now, let us see the Excel TEXTJOIN function in action with the help of some interesting examples. 

Use TEXTJOIN to Combine Names 

You can use the formula =TEXTJOIN(“ “,1,A2,B2) to join the names in cells A2 and B2 together with a space in between them. Notice that here I have used a binary input for ignore_empty. 

Using TEXTJOIN to combine names
Using TEXTJOIN to combine names

The formula=TEXTJOIN(” ,”,1,A3,B3) will join the names in cells E2 and B2 together with a comma in between them.  

Using a comma as the delimiter in TEXTJOIN
Using a comma as the delimiter in TEXTJOIN

Use TEXTJOIN to Concatenate a Range

Use the formula, =TEXTJOIN(“ – “,TRUE,E1:G1), to concatenate the entire range (E1 to G1) in one go. 

Using TEXTJOIN on a range
Using TEXTJOIN on a range

You can also concatenate individual cells and ranges inside the TEXTJOIN function. For example, the formula, =TEXTJOIN(“-“,TRUE,E1:G1,I1), will concatenate each value inside the range E1 to G1 and finally join it with I1. 

Using TEXTJOIN to join a cell and a range
Using TEXTJOIN to join a cell and a range

How to Keep Source Formatting in TEXTJOIN?

If you are using the TEXTJOIN function to concatenate dates or other special formats, Excel will either display a #VALUE error or strip the special formatting before it joins them together.

Directly Using TEXTJOIN to combine text and dates results in value error
Directly Using TEXTJOIN to combine text and dates results in value error

To avoid this, convert these special formats to text strings using the TEXT function, like this, TEXT( B2, “mm/dd/yy”), before using them inside the TEXTJOIN formula. 

TEXTJOIN with TEXT function to combine text and dates
TEXTJOIN with TEXT function to combine text and dates

Things to Keep in Mind about TEXTJOIN

  1. The CONCAT function is very similar to the TEXTJOIN function, except that the delimiters have to be entered every time in between two strings. 
  2. A simpler method than CONCAT is to use the “&” operator, also known as the ampersand method. 
  3. TEXTJOIN works only in Excel 2019 and Office 365 versions of Excel. 

Suggested Reads:

How to Enable Excel Dark Mode? 3 Simple Steps

How to Delete a Pivot Table in Excel? 4 Best Methods

How to Make Excel Track Changes in a Workbook? 4 Easy Tips

Closing Thoughts

In this guide, I have shown how to properly use the Excel TEXTJOIN function. Do try these methods in a rough spreadsheet to gain a better understanding. If you have any questions about this or any other Excel feature, feel free to let us know in the comments. We’re always happy to help. 

Visit our free Excel Resources Centre for more high-quality Excel guides. 

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Similar Posts

Using the LET Function in Excel

How to Use Nested VLOOKUP in Excel? A Step-by-Step Guide

How to Fix the #REF Error in Excel? 3 Easy Methods

How to Make a Histogram in Excel?—2 Best Methods

How to Make a Checklist in Word? 3 Simple Steps

How To Setup Preferences in QuickBooks Pro 2017 Part 1

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)