I start by demonstrating how to use CONCATENATE to combine the last name and first name columns with a space in between. If you want to use a different delimiter, such as a comma, you can easily do that too.
Next up is TEXTJOIN, a powerful function that combines data from multiple cells with the added option to ignore empty cells and specify a delimiter. While this function isn’t available in all versions of Excel, it’s definitely worth checking out if you have access to it.
Finally, I cover the CHAR function, which allows you to insert line breaks in your text. I’ll show you how to use CHAR in combination with TEXTJOIN to put address one above address two, with a line break in between.
Whether you’re a beginner or an experienced Excel user, this video is a great resource for learning these three functions and improving your data manipulation skills. Don’t forget to check out the chapters listed below for easy navigation. Thanks for watching, and don’t forget to subscribe and ring the bell for more Excel tips and tricks!
Availability for TEXTJOIN Funciton
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, and Excel 2019 for Mac
— EQUIPMENT USED ———————————
My camera – https://amzn.to/3vdgF5E
Microphone – https://amzn.to/3gphDXh
Camera tripod – https://amzn.to/3veN6Rg
Studio lights – https://amzn.to/3vaxyy5
Dual monitor mount stand – https://amzn.to/3vbZSjJ
Web camera – https://amzn.to/2Tg75Sn
Shock mount – https://amzn.to/3g96FGj
Boom Arm – https://amzn.to/3g8cNi6
— SOFTWARE USED ———————————
Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
Screenshots – Snagit – https://chrismenardtraining.com/snagit
YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Take the opportunity to connect and share this video with your friends and family if you find it useful.
Keywords: excel textjoin, excel char, excel concatentate, excel join text, join text in excel, textjoin function in excel, Use TEXTJOIN, Excel TEXTJOIN FOR WINDOWS, chris menard, chris menard training, CHAR Function