How to easily combine data into one cell in Excel (and why I stopped using CONCATENATE)

Want to learn how to How to easily combine data into one cell in Excel? In this video I show how to use Excel String Functions: CONCATENATE, CONCAT, TEXTJOIN & More - you'll never guess which is my favorite! Check out this Easy Excel Tutorial and learn how! 🚀 Ready to elevate your Excel skills? In this tutorial, we delve into the powerful world of string manipulation in Excel. Whether you're a beginner or looking to sharpen your skills, this video is your go-to guide for combining text in Excel. What You'll Learn: - CONCATENATE Function: Discover the classic way to join text strings. Ideal for Excel veterans and compatible with older versions. - CONCAT Function: A step forward from CONCATENATE, this function, available in Excel 2016, Excel Mobile, and Excel for the web, offers a modern approach to text joining. - TEXTJOIN Function: Experience the advanced capabilities of Excel with TEXTJOIN. This function not only combines texts but also provides options for delimiters and ignoring empty cells. - Ampersands (&) for Text Combination: Learn the quick and straightforward method of joining texts using ampersands - perfect for concatenating first and last names seamlessly. 👍 Found this tutorial helpful? Like, Share & Subscribe for more Excel tips and tricks! 📢 NEW Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://www.tmbanalytics.com/excel-daily-guide-yt 🫵 Are you ready to take on the 7 Days to Excel Challenge and join the #nomouseclub❓ 👉 Click here if you dare: https://www.tmbanalytics.com/7-days-to-excel-challenge-yt VIDEO TOPICS: 0:00 - Intro 0:20 - CONCATENATE Function 2:50 - CONCAT Function 4:15 - TEXTJOIN Function 5:25 - Using Ampersands (&) 7:00 – Free Excel Guide LEARN MORE ABOUT USING EXCEL FOR ANALYSIS: Excel for Analytics - Portfolio Project Series Video 1 - Quick Excel Tips https://youtu.be/45_yTM1HfTc?si=aePKgQeKUQqtH9qQ Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel https://youtu.be/_jEGuoXz02c?si=Yqgx_dzq7OfoXjrC Excel for Analytics - Portfolio Project Series Video 3 - Data Exploration and Analysis in Excel https://youtu.be/mCznZ_KMgWQ?si=DQJhQN_1N38Z6fSX Excel for Analytics - Portfolio Project Series Video 4 - Data Presenting in Excel https://youtu.be/BDbpJLp6zhI?si=LJ4Y2AOmC_YyqIB4 OTHER EXCEL TOPICS: I dont use Pivot tables in Excel...and it has helped my career https://youtu.be/qTteZ5pUWvU The MOST Ultimate Excel LOOKUP Guide | Can you guess which is my favorite? https://youtu.be/Ck42XbpiC6I #excel #pivottable #exceltips #spreadsheet