Excel Tutorial – Cleaning Up Data with TRIM, PROPER, and Text to Columns




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads