In this video, you will learn the top 3 methods for quickly splitting a cell into multiple columns so your data is prepped and ready for analysis. By the end of this tutorial, you’ll be able to split data into multiple columns in seconds using Excel built-in data tools, formulas, and even shortcuts!

First, you’ll learn how to split text using the Text to Columns tool, then how to split data using Excel’s new TEXTSPLIT function, and lastly, how to split cells using the Flash Fill shortcut.

RESOURCES
– Download this workbook and follow along: https://excel-dictionary.com/pages/youtube-workbook

SHOP EXCEL DICTIONARY
– COURSES: https://excel-dictionary.com/collections/courses
-GUIDES: https://excel-dictionary.com/collections/e-books
-MERCH: https://excel-dictionary.com/collections/merch
-TEMPLATES: https://excel-dictionary.com/collections/templates

NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subscribe

SUBSCRIBE
-Subscribe to never miss a video: https://www.youtube.com/c/ExcelDictionary

️CHAPTERS
‘0:00 Intro
‘0:26 Text To Columns Tool
‘1:57 TEXTSPLIT Function
‘2:53 Flash Fill Shortcut
‘4:01 Wrap Up
#excel #exceltips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.