Answered by : riccardo-biffi

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

Source : https://www.ablebits.com/office-addins-blog/trim-spaces-between-words/ | Last Update : Fri, 08 Jul 22

Answered by : gorgeous-grasshopper-lgnr4h7hjylg

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

Source : | Last Update : Sun, 17 Jul 22