How to clean data in excel ?
How to clean up raw data for processing in Excel. if you have multiple spaces in between numbers you can easily clean it through demonstrated formulas which are stated below.
Formula 1:
=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160),"")))
Formula 2:
=SUBSTITUTE(A2," ","")
Please see details in tutorial to apply these properly.
Watch video How to clean data in excel ? online without registration, duration hours minute second in high quality. This video was added by user Excel to Excel 30 June 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,66 once and liked it 4 people.