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.