@excel.scholar: TRIM & PROPER in Excel. TRIM: Removes leading and trailing spaces, and collapses multiple internal spaces into one. PROPER: Capitalizes the first letter after any non-letter character (spaces, hyphens, etc.) and lowercases everything else. #excel #spreadsheets #exceltips #microsoftexcel