CODE EXAMPLE FOR EXCEL

remove space from excel cell

Remove trailing and leading spaces:
	=TRIM(A1)

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