Thanks to TRIM function you can remove spaces from the text. Syntax of TRIM function is: =TRIM(text). If you have text with extra spaces in A1 cell, just writhe a formula =TRIM(A1). TRIM function remove extra spaces which you doesn't need.