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: • Excel: How to use TEXTSPLIT function
TEXTBEFORE and TEXTAFTER: • Excel: Using the TEXTBEFORE and TEXTAFTER ...
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.
#excel #microsoftexcel #microsoft365 #learnexcel #exceltutorial #exceltraining #excellesson #excelfunction
Sur cette page du site, vous pouvez voir la vidéo en ligne Excel: Join text together using the TEXTJOIN function durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur jargonfreehelp 21 novembre 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 752 fois et il a aimé 3 téléspectateurs. Bon visionnage!