Channel: Teacher's Tech

Category: Education

Tags: excel tutorialsplitting cells in exceljamie keetsplit cells with text in excelpower query to split cells in excelformulas in excelmicrosoft excelexcelmicrosoft excel tutorialhow to split cells in microsoft excelflash fill to split cells in excelteacher's techtext to columns in excel

Description: 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: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EajuvC9QWE5LvMq3EGcXcM0BysZsU4RPhgCFHoOFlYhWSA?e=0KPovs My Microsoft Excel Playlists Beginner Microsoft Excel Tutorials: youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw How to use functions and formulas in Excel: youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST 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