USE THE TRIM FUNCTION TO DELETE SPACES IN MICROSOFT EXCEL

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->.

USE THE TRIM FUNCTION TO DELETE SPACES IN MICROSOFT EXCEL