Excel to Excel | How to clean data in Excel? @ExceltoExcelE | Uploaded 11 months ago | Updated 10 hours ago
Easy technique to clean data
=TRIM(CLEAN(SUBSTITUTE(C2,CHAR(160),"")))
=SUBSTITUTE(D2," ","")
Easy technique to clean data
=TRIM(CLEAN(SUBSTITUTE(C2,CHAR(160),"")))
=SUBSTITUTE(D2," ","")
![How do you create your own diary? [No template required.]](https://i.ytimg.com/vi/S-LRlornFwA/hqdefault.jpg "How do you create your own diary? [No template required.]
very simple way of creating an excel diary and calendar")
