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: • 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
On this page of the site you can watch the video online Excel: Join text together using the TEXTJOIN function with a duration of hours minute second in good quality, which was uploaded by the user jargonfreehelp 21 November 2022, share the link with friends and acquaintances, this video has already been watched 752 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
