textjoin()

[lezawang]

Hi
In the table below, what I did is something different from the orginal example 3 in Microsoft page. I did =TEXTJOIN($A$8:$D$8,TRUE,A2:D2)
the autofill the reset of the column. MS page did this =TEXTJOIN(A8:D8, TRUE, A2:D7) - the link below please.
My question, in my case why ";" was not added to the end of each line in column D? Thank you very much.

PS: i do not see big advantage of textjoin() to concatenate() ? Thanks

TEXTJOIN function - Microsoft Support

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

support.microsoft.com

Book2
	A	B	C	D	E	F
1	City	State	Postcode	Country
2	Tulsa	OK	74133	US		Tulsa,OK,74133,US
3	Seattle	WA	98109	US		Seattle,WA,98109,US
4	Iselin	NJ	8830	US		Iselin,NJ,8830,US
5	Fort Lauderdale	FL	33309	US		Fort Lauderdale,FL,33309,US
6	Tempe	AZ	85285	US		Tempe,AZ,85285,US
7	end					end
8	,	,	,	;
Sheet1

Cell Formulas
Range	Formula
F2:F7	F2	=TEXTJOIN($A$8:$D$8,TRUE,A2:D2)

 

[Dossfm0q]

because you join row by row and delimiter only added in-between to add at the End =TEXTJOIN($A$8:$D$8,TRUE,A2:D2)&";"

count wrd.xlsx
	A	B	C	D	E	F
1	City	State	Postcode	Country
2	Tulsa	OK	74133	US		Tulsa,OK,74133,US;
Sheet3

Cell Formulas
Range	Formula
F2	F2	=TEXTJOIN($A$8:$D$8,TRUE,A2:D2)&";"

or move";"

count wrd.xlsx
	A	B	C	D	E	F
1	City	State	Postcode	Country
2	Tulsa	OK	74133	US		Tulsa,OK,74133;US
3	,	,	;
Sheet3

Cell Formulas
Range	Formula
F2	F2	=TEXTJOIN($A$3:$C$3,TRUE,A2:D2)

 

[Dossfm0q]

You can also Use array As {",",",",";"}

Book1
	A	B	C	D	E	F
1	City	State	Postcode	Country		Result
2	Tulsa	OK	74133	US		Tulsa,OK,74133;US
Sheet1

Cell Formulas
Range	Formula
F2	F2	=TEXTJOIN({",",",",";"},TRUE,A2:D2)