Excel Forum



YTLE#74: CLEAN & TRIM functions to fix Bad Data


See how to fix bad data with the CLEAN & TRIM functions. TRIM gets rid of extra spaces. Clean gets rid of Line Breaks and non-printing characters.





Got a Question? Ask it Here in the Forum.