About Course
Clean up messy imported data in minutes. Learn how to split full names, addresses and codes into separate columns with Text to Columns and TEXTSPLIT, and how Flash Fill recognises a pattern from your example and fills the rest of the column for you.
Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.
Course Content
Course Lessons
-
Why data needs splitting and cleaning
-
Text to Columns step by step
-
Flash Fill: fill by example
-
Formulas that split text
Sources & Further Reading
Final Assessment
Student Ratings & Reviews
No Review Yet