![]() ![]() If there is a huge data set, doing this manually could take hours. You may want to fill all blank cells with ‘0’ or ‘Not Available’, or may simply want to highlight it. I often face issues with blank cells in a data set that is used to create reports/dashboards. #2 Select and Treat All Blank Cellsīlank cells can create havoc if not treated beforehand. It removes leading and trailing spaces as well as the additional spaces between words (except single spaces). ![]() ![]() Here is a neat way to get rid of these extra spaces – Use TRIM Function.Įxcel TRIM function takes the cell reference (or text) as the input. While you may somehow spot the extra spaces between words or numbers, trailing spaces are not even visible. #10 Use Find and Replace to Clean Data in ExcelĮxtra spaces are painfully difficult to spot.#6 Change Text to Lower/Upper/Proper Case.#3 Convert Numbers Stored as Text into Numbers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |