CODE EXAMPLE FOR EXCEL

how to remove spacing in excel

Remove trailing and leading spaces:
	=TRIM(A1)

Remove all spaces:
	=SUBSTITUTE(A1," ","")
	Using find and replace