top of page

Microsoft Excel articles et conseils

Excel Icon.png
Back Button

Use the TEXTJOIN function to quickly and easily string content from a range of cells together.

Available in 365 and 2019 versions of Excel, the TEXTJOIN function allows you to easily combine text from multiple ranges and/or strings, plus includes a delimiter you specify only once to be included between each text value.  If the delimiter is empty, the function will concatenate the ranges.

EXAMPLE 1:  

You would like to transform this:

textjoin_1.jpg

To this, which you can then use in Excel, or copy and paste into any program:

textjoin_2.jpg

EXAMPLE 2:  

You would like to transform these email addresses:

textjoin_3.jpg

To a list of email addresses in an Outlook, or other email program, message:

textjoin_4.jpg

Here are the two TEXTJOIN formulas you would use.

 

The 1st argument is Delimiter, which is a character or string within double quotes; the 2nd argument is Ignore_Empty, the default to ignore empty cells; the 3rd argument, Text1, is the range or strings to join. We have used a table column, but you can also refer to range(s) of cells.

EXAMPLE 1 FORMULA:

  =TEXTJOIN(",",,tblAttendees[Attendees])

EXAMPLE 2 FORMULA:

  =TEXTJOIN(";",,tblEmails[Email Addresses])

Would you like to learn more about TEXTJOIN or other Excel functions? Contact us!

© 2022 DJH Training & Application Solutions Inc.

bottom of page