CONCATENATE VS CONCAT VS TEXTJOIN - Join Text From Different Cells Together In Excel
We cover how to join two or more items into one string in Excel using CONCATENATE, CONCAT and TEXTJOIN, ultimately evaluating which function is best. These functions reduce the need to manually connect text, therefore helping you save a lot of time. In this video, I cover 5 main examples of CONCATENATE, CONCAT and TEXTJOIN to give you a good idea of the main applications you need to know.
Access the file here:
https://box.docuspace.net/index.php/s...
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• CONCATENATE VS CONCAT VS TEXTJOIN - J...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Simple CONCATENATE: (0:36)
The Power Of CONCAT: (1:55)
Concatenating Words In A Sentence With TEXTJOIN: (2:46)
Ignoring Empty Text With TEXTJOIN: (3:45)
Concatenating Text With Conditions: (4:51)
Evaluation: (5:55)