Learn Different Ways to Combine Cells in Microsoft Excel

Teacher's Tech November 17, 2021
Video Thumbnail
Teacher's Tech Logo

Teacher's Tech

@teacherstech

About

🌟 This is the channel where tech finally makes sense! I'm Jamie, an avid tech enthusiast and educator, and I'm here to make your journey into tech a whole lot easier. Forget complicated jargon and confusing tutorials. I make beginner-friendly videos that explain tech concepts in plain English, step by step. In today's fast-paced world, the right tech tools can be a game-changer. That's why I'm here! I break down important business and education apps into simple steps, so you can unlock their power and boost your productivity. If you're ready to get started with tech without the overwhelm, make sure to subscribe to my channel 💡

Video Description

In this Microsoft Excel tutorial, I will show you how to combine cells in Microsoft Excel using different methods like Flash Fill, the Ampersand &, Functions (CONCATENATE, CONCAT, TEXTJOIN), and Power Query. So when you need to merge or combine cells in Microsoft Excel consider one of these methods. Practice sheet: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EaxIh4c8dUhFl3TgTpLUbQIBUjeypUWhXVSY0JbaK_NteA?e=X6cztf My Microsoft Excel Playlists Beginner Microsoft Excel Tutorials: https://youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw How to use functions and formulas in Excel: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST 0:00 Introduction 0:50 Using Flash Fill in excel 1:44 Combining cells with the Ampersand (&) in Excel 3:03 How to use the CONCATENATE function 4:44 How to use the CONCAT function in Microsoft Excel 7:42 How to use the TEXTJOIN function in Microsoft Excel 9:14 Using Power Query to combine cells in Excel

You May Also Like