About this tutorial:
Video duration: 00:13:50
In this Excel tutorial, you’ll learn how to clean up data using the TRIM, PROPER, and Text to Columns functions (and more).
By “Financial Modeling Training And Career Resources For Aspiring Investment Bankers”
Why Do You Need to “Clean Up” Data? Often you’ve pasted in data from websites or PDFs or other sources, and you get lots of ugly formatting and other problems, such as extra spaces, non-printable characters, etc.
Also, data may be grouped together in cases where it’s better to be separated (as in the address data here).
This happens all the time…