TRIM as the Tree Comes Down

Merry Christmas! I hope you are enjoying the holiday and spending more time with friends and family — and maybe less with your spreadsheets!

Here is an appropriate Excel tip as your Christmas tree comes down. TRIM will remove all excess spacing from text while leaving one space between words.

Useful function — many software systems will export data into Excel with excess spacing, so TRIM is a quick, efficient way to clean up your data.