How to remove blank space in excel sheet

remove space from excel cell

Remove trailing and leading spaces:
	=TRIM(A1)

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