Title: 10 Super Neat Ways to Clean Data in Excel Spreadsheets
Headings: 10 Super Neat Ways to Clean Data in Excel Spreadsheets
10 Super Neat Ways to Clean Data in Excel Spreadsheets
FREE EXCEL TIPS EBOOK - Click here to get your copy
Watch Video – 10 Ways to Clean Data in Excel
In this blog post, I will show you 10 simple ways to clean data in Excel.
This Tutorial Covers:
#1 Get Rid of Extra Spaces
Syntax: TRIM (text)
#2 Select and Treat All Blank Cells
#3 Convert Numbers Stored as Text into Numbers
#4 – Remove Duplicates
#5 Highlight Errors
Using Conditional Formatting
Using Go To Special
#6 Change Text to Lower/Upper/Proper Case
#7 Parse Data Using Text to Column
#8 Spell Check
#9 Delete all Formatting
#10 Use Find and Replace to Clean Data in Excel
You May Also Like the Following Excel Tutorials:
FREE EXCEL BOOK
Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Content: 10 Super Neat Ways to Clean Data in Excel Spreadsheets
10 Super Neat Ways to Clean Data in Excel Spreadsheets
-- By Sumit Bansal
FREE EXCEL TIPS EBOOK - Click here to get your copy
Watch Video – 10 Ways to Clean Data in Excel
Data forms the backbone of any analysis that you do in Excel. And when it comes to data, there are tons of things that can go wrong – be it the structure, placement, formatting, extra spaces, and so on. In this blog post, I will show you 10 simple ways to clean data in Excel. This Tutorial Covers: #1 Get Rid of Extra Spaces
#2 Select and Treat All Blank Cells
#3 Convert Numbers Stored as Text into Numbers
#4 – Remove Duplicates
#5 Highlight Errors
#6 Change Text to Lower/Upper/Proper Case
#7 Parse Data Using Text to Column
#8 Spell Check
#9 Delete all Formatting
#10 Use Find and Replace to Clean Data in Excel
#1 Get Rid of Extra Spaces
Extra spaces are painfully difficult to spot. While you may somehow spot the extra spaces between words or numbers, trailing spaces are not even visible. Here is a neat way to get rid of these extra spaces – Use TRIM Function. Syntax: TRIM (text)
Excel TRIM function takes the cell reference (or text) as the input. It removes leading and trailing spaces as well as the additional spaces between words (except single spaces).