Learn Different Ways to Combine Cells in Microsoft Excel
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
Видео Learn Different Ways to Combine Cells in Microsoft Excel канала Teacher's Tech
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
Видео Learn Different Ways to Combine Cells in Microsoft Excel канала Teacher's Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
5 Amazing Google Docs Hacks!Revolutionize Your Guide Creation: Auto-Generate with ScribeHow to use Threadit - Video meetings you don't need to be at!Set Goals in Google Calendar - New FeatureMake Microsoft Excel WAY Smarter?Google Drive Tutorial - Managing DriveRepair Documents in Microsoft Word. Make Old Look New!Create an Interactive Chart with Checkboxes in Microsoft ExcelRelative vs Absolute Cell Reference in Microsoft Excel - What's the difference?Microsoft OneNote for Windows 10 Tutorial - Beginner's Level 2Create Drone-Style Videos for FREE with Google Earth StudioHow to Remove a Background from an ImageHow to use the NEW Microsoft Planner in TeamsEasy Podcasting for Teachers and Students with Synth3 Powerful Camera Features with Google App on a iPhoneCreate Excel Pivot Table from Multiple Sheets: The FASTEST WayHow to use the XLOOKUP Function in Microsoft Excel - Beginners TutorialMail Merge Made Easy: From Excel to Word to Outlook7 Tips in Microsoft Word You May Not Know AboutMicrosoft OneNote for Windows 10 - Tips and Tricks