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 – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – 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!

• Excel TEXTJOIN, CONCATENTATE and CHAR Functions to Join Text ( Download)
• Concatenate Excel Tutorial ( Download)
• How to use the TEXTJOIN function in Excel ( Download)
• How to use textjoin formula in excel |difference Between Concatenate & text join |Advance excel ( Download)
• How to Merge Data From Multiple Columns Using TextJoin & Concatenate Functions | Excel ( Download)
• How to Use the TEXTJOIN Function in Excel ( Download)
• Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text | Concatenate with IF Condition ( Download)
• TEXTJOIN function in Excel ( Download)
• CONCATENATE vs CONCAT vs TEXTJOIN formula in Excel | Understand the difference! ( Download)
• Excel How To Combine or Join Text (3 Easy Ways) ( Download)
• Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE ( Download)
• MS Excel - TEXTJOIN & IF Function | Excel Function ( Download)
• Choosing the Right Text Function: CONCATENATE vs CONCAT vs TEXTJOIN in Excel ( Download)
• 3 Ways to Combine Text Strings: Concatenate, Textjoin, & ( Download)
• Get Started With Excel TEXTJOIN Function ( Download)