In this video tutorial, I will show you how to split cells in Microsoft Excel using four different methods like Flash Fill, Text to Columns &, Formulas with Functions (LEFT, RIGHT, SEARCH, LEN), and Power Query. So when you need to split or divide cells in Microsoft Excel consider one of these methods.


Practice Sheet: https://leveragingdigitalincmy.share...


My Microsoft Excel Playlists
Beginner Microsoft Excel Tutorials:    • Excel for Beginners: Easy Steps to Ge...  
How to use functions and formulas in Excel:    • Formulas and Function in Microsoft Excel  


0:00 Introduction
1:28 Using Flash Fill in excel to split cells
3:17 Text to Columns to divide cells in Excel
4:51 Building a formula with functions to split cells in Microsoft Excel
11:17 Using Power Query to split cells