Download and install this macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Then select the range of cells in question.
Run the macro
--
Biff
Microsoft Excel MVP
"sjs" wrote in message
...
I'm trying to run a vlookup but the search array has some cells that
contain
data in which there is a space at the end. Is there an easy way to remove
the end space when only some of the cells have the space?
tks,
steve