Biff, not sure installing a macro is safe, virus wise. Any other way to
remove the space?

tks,
steve

"T. Valko" wrote:

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