Remove extra spaces from text/ numbers in Excel cells

00:00 Remove extra spaces from Excel cells
00:10 SUMIF/ VLOOKUP are wrong if there is a trailing space
00:50 Excel function to remove extra spaces (leading, trailing and double spaces)

Using the TRIM function to remove extra spaces in cells that can cause problems (grammatically but also for Excel functions like SUMIF and VLOOKUP).