Excel Functions Textjoin VS Concat

[JulieBunavicz]

General Question

Anyone know if it makes a difference to combine cells with TEXTJOIN or CONCAT? Below are examples I’ve found useful as a Data Analyst.

=TEXTJOIN( " ", TRUE, A2:B2, TEXT(C2, "mm/dd/yyyy") ) ---Same as below
=TEXTJOIN( " ", TRUE, TEXT(S2, "mm/dd/yyy"), TEXT(T2, "hh:mm") ) --with time and date
=D8&" "&AY8&" ("&TEXT(AT8,"mm/dd/yyyy")&")" ---Same as above

Kind regard,

Julie Bunavicz

 

[NateSC]

CONCAT will combine all the provided strings together.
TEXTJOIN will place the specified delimiter between all the provided strings.

If you want a space between everything, you have to add it in every time with CONCAT.

=CONCAT("1","2","3") = 123
=CONCAT("1","-","2","-","3") = 1 2 3
=TEXTJOIN("-",TRUE,"1","2","3") = 1 2 3