Use the TRIM function to delete spaces in Microsoft Excel - Text Functions - Microsoft Excel Tutorials

Column A of a worksheet contains text with spaces at the left and right side of the text. This could be a problem if, for example, data is used for evaluation.  Use the TRIM Text function to remove all spaces from a text string except for the single spaces between words. 

 To delete unneeded spaces from text:

1. In cells A2:A5, type text with leading and trailing spaces.
2. Select cells B2:B5 and type the following formula: =TRIM(A2).
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=hfbtQDMJ5m4