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: [ Ссылка ]
My Microsoft Excel Playlists
Beginner Microsoft Excel Tutorials: [ Ссылка ]
How to use functions and formulas in 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
