Combine Text & Values in Excel like a pro!

In this video you will learn how to combine a text to a value in Excel, which can be really handy while building dashboards in your files. We will cover the functions CONCATENATE, CONCAT and you will also learn a technique to connect 2 or more strings with the ampersand (&) symbol. At the end of the video I will also show you how to create a standard dynamic message in Excel which can be adapted by the click of a button. Make sure you watch the whole video!

Intro 0:00
Functions CONCATENATE & CONCAT 0:41
Combining Text and Values with Ampersand (&) 4:41
Building a dynamic message in Excel 6:23
Final Thoughts 11:06

Download the Excel file used in this video:

Do you want to learn more about the function TEXT which I covered briefly on this video? So, check the link below: