Excel TEXTJOIN, CONCATENTATE and CHAR Functions to Join Text

Channel Avatar
Comment
X
Share
Excel TEXTJOIN, CONCATENTATE and CHAR Functions to Join Text
Excel TEXTJOIN, CONCATENTATE and CHAR Functions to Join Text
In this video, I’ll be discussing three Excel functions that help you join text together: CONCATENATE, TEXTJOIN, and the CHAR function. If you’re looking to combine data in multiple cells into one cell, then this video will explain in detail how to achieve that.

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!

Chapters:
00:00 Introduction
00:53 CONCATENATE
02:08 TEXTJOIN
04:06 CHAR

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

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *