Microsoft Excel Tips and Tricks
In this Excel video tutorial I demonstrate the new Clean Data tool which quickly removes unwanted spaces in text strings. These spaces typically cause problems when performing VLOOKUPs or XLOOKUPs.
Credit Chester Tugwell