Excel: Join text together using the TEXTJOIN function

If you want to join text together in Excel you could use concatenation or use the & sign to do the same thing. Now there is a new function called TEXTJOIN that can do this more easily and has some other functions. It also allows you to select a range to join them together: Other recently added text functions include: TEXTSPLIT: /watch/sUBWP_KjxK-jW TEXTBEFORE and TEXTAFTER: /watch/AGYDqKerGDbrD If you want to see more then check out my website http://www.jargonfreehelp.com This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

الفئة