New Function TEXTJOIN

This Function Distributed with Jan 2016 updates for Excel 2016. Please make sure you have installed latest version of excel and is updated. Otherwise, you can't use this function.

This function joins the texts with any delimiter we define. Syntax for the function is

TEXTJOIN(delimiter,ignore empty,text1,text2.........)

Delimiter - The delimiter between two texts. This can be space, any single charactor or many charactors. Should be enter within double quotes.
Ignore Empty - If we set 'True', Function will ignore any empty cell if referred.
Text1 - First text to be join
Text2, Text3.......... - Other texts to be join.

See below examples

	A	B	C	D
1	Desktop	Computor
2	HP	60	Black	Ink
3	Laptop		Comutor
4	HP	Scaner
5	8	GB	Flash	Drive
6	HP	Inject	Printer

=TEXTJOIN(" ",TRUE,A1:D1) will return Desktop Computer.

Blank cells ignored because ignore empty is True.

Space between two texts because Delimiter is Space

=TEXTJOIN("-",TRUE,B3:E3) will return HP-60-Black-Ink

Here "-" between two texts because it is the delimiter

=TEXTJOIN("-",FALSE,B4:E4) will return Laptop--Comutor-

Here additional "-" because ignore empty is False

If we set ignore empty to true, output will be Laptop-Comutor.

You can dowload example file here.

You can discover more about this function from Microsoft Ofice Help.