Description

TEXTJOIN is a text function in Excel. Using this function you can join value from multiple cells or a range with a delimiter. This function has an option to consider or ignore empty cells

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Example

You can select a delimiter in TEXTJOIN Excel function to join the text.
In this example we used “,” as delimiter and select a range with TEXTJOIN.
We can ignore empty cells by using “TRUE” in second argument.

0 Comments

By Rajesh K Saraogi

Rajesh is a hardcore finance person with a penchant for latest technology. His passions are latest technology and to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!

Text Functions