MS Excel | combine data with the TEXTJOIN function

The syntax for the JOINTEXT formula is as follows:

=TEXTJOIN(" ", TRUE, text2)

Notes: After instructing Excel to use the JOINTEXT function. We need to open a quote mark and tell Excel which delimiter we will be using. As the delimiter is simply either a character or symbol, that will set a boundary between our pieces of data. We are going to use a blank space. However, instead of a space we could also use a period or comma.

When we close the quote marks, we have a add a comma to instruct Excel to move onto the next action. We then need to use a logic statement so that Excel knows to either include or skip blank cells. After using another comma, we finally need to tell Excel where to look for the data we wish to join together.

This is an example of an actual JOINTEXT formula:

=TEXTJOIN(" ",TRUE,A2:B2)

Note: If we were to use FALSE instead of TRUE. The TEXTJOIN function will include any blank cells in the results.

• mydoodads article – MS Excel | combine data with the CONCAT function.
• mydoodads article – MS Excel | Customise your instance of Excel.
• mydoodads article – MS Excel | How to turnoff the Startup screen.

• Microsoft article – TEXTJOIN Function.
• Microsoft article – CONCAT Function.
• Microsoft article – CONCATEATE function.