Remove leading and trailing spaces from text

http://numintocharexcel.blogspot.com/2016/08/how-to-remove-spaces-from-cell.html

If you need to strip leading and trailing spaces from text in one or more cells, you can use the TRIM function.

In the example show, the formula in cell C3 is:

=TRIM(B3)