You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
Text » Delete leading and trailing spaces
This utility removes all spaces from the beginning and end of the values in your selected cells.For example if you have a cell with the value " Excel " then this utility changes the value to "Excel" without the spaces at the front and end.
Starting this utility
In the Excel menu choose ASAP Utilities » Text » Delete leading and trailing spacesAdditional keywords:
extra spaces, remove excessive whitespace, unnecessary spaces, white space
extra spaces, remove excessive whitespace, unnecessary spaces, white space
« Return to the list of “Text” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 