Excel Basics: How to Clean Up Data in Excel

Fix a messy list: trim stray spaces, swap values with Find and Replace, split names into columns, remove duplicate rows and find blank cells. ✓ Remove stray spaces with TRIM and keep the cleaned values ✓ Replace one value with another across a sheet with Find and Replace ✓ Split one column into two with Text to Columns ✓ Remove exact duplicate rows ✓ Select every blank cell at once with Go To Special