The TRIMRANGE function offers an easier and more flexible way to tidy up an Excel sheet, especially with the addition of Trim Refs. Clean Up Data Effortlessly With Excel's New TRIMRANGE Function ...