Three ways to join text together in Microsoft Excel:
1. the Join operator (&)
2. the CONCAT function
3. the TEXTJOIN function
Some of the functions used in this video:
=B2&" / "&D2&" / "&F2&" / "&H2&" / "&J2
=CONCAT(B2," / ",D2," / ",F2," / ",H2," / ",J2)
=TEXTJOIN(" / ",TRUE,B2,D2,F2,H2,J2)
=TEXTJOIN(", ",TRUE,M2:Q2)
