How to use the TRIM function in EXCEL for DATA CLEANING!

How to use the TRIM function in EXCEL for DATA CLEANING!

The “TRIM” function is a useful feature in EXCEL for Data Cleaning. It that allows users to remove all spaces in a text, except for single spaces between words and characters. Sounds interesting? Learn how to use it in this video!

Other related resources to this video:
~ EXTRACT TEXT FROM CELLS with LEFT, MID & RIGHT EXCEL Functions!
   • EXTRACT TEXT from cells with LEFT, MID & R...  
~ CHANGE TEXT CASE in EXCEL using UPPER, LOWER, PROPER & FLASH FILL!
   • CHANGE TEXT CASE in EXCEL using UPPER, LOW...  
~ How to use the TRIM function in EXCEL for DATA CLEANING!
   • How to use the TRIM function in EXCEL for ...  
~ How to convert an EXCEL file into TEXT TAB DELIMITED file!
   • How to convert an EXCEL file into TEXT TAB...  
~ How to convert a TEXT TAB DELIMITED file into EXCEL!
   • How to convert a TEXT TAB DELIMITED file i...  
~ How to use TEXT TO COLUMNS in EXCEL for DATA CLEANING!
   • How to use TEXT TO COLUMNS in EXCEL for DA...  


By Cedric Ng,
AUTHOR of International Best Sellers,
~ “Predictive HR Analytics, Text Mining & ONA with Excel” &
~ “IISS: Employee Experience & Engagement with Predictive Analytics”
https://www.amazon.com/s?k=ng+mong+shen
~ Subscribe to my YouTube channel at:    / thehrdiary  
~ Follow my Facebook page at:   / thehrdiary  
~ Check out Books at: https://www.amazon.com/s?k=ng+mong+shen