In this Excel tutorial, you'll learn how to clean up data using the TRIM, PROPER, and Text to Columns functions (and more).
By http://breakingintowallstreet.com/ "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.
http://www.mergersandinquisitions.com/