LEARN HOW TO SPLIT DATA FROM ONE CELL INTO MULTIPLE COLUMNS USING TEXT TO COLUMNS IN EXCEL // Learn how to split text (like first and last name) into multiple columns in Excel. Or use Text to Columns to separate a column of 9-digit zip codes into just the first 5-digits of the zip code. Using either a fixed width or delimiter like a comma, period or other character like the @ symbol, you can take a single column of data and split it into multiple columns.

Find the Text to Columns feature on the Data ribbon under Data Tools. The Convert Text to Columns wizard will appear.
__________
FREE DOWNLOADS:
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads including helpful spreadsheet formulas, dashboards and other templates.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.

LinkedIn: https://www.linkedin.com/in/sharonsmithhr

Twitter: https://twitter.com/SharonSmithHR
__________
RESOURCES:
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
__________
NOTE: Some links included here are affiliate links. If you click on these links and make a purchase, we may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #ExcelTutorials, text to columns, excel tips and tricks, fixed width vs delimiter, HR spreadsheet tips, MS Excel tutorial, HR tutorial
__________
PLAYLISTS:
Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR