Importing large sets of data in Excel can sometimes result in less-than-ideal formatting. Watch this 13-minute video tutorial to learn how to Merge and Split columns in Excel to suit your needs. Learn a data cleaning trick by splitting columns using text to columns in excel.

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for PivotTables https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

Pivot Tables - All you can Eat playlist here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Advanced Pivot Tables in Excel here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hhKEX9VBkzc8_bJ3Yjd6Pd

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)