use the TRIM() function. It removes trailing spaces.
--
Gary''s Student - gsnu200713


"Mr. Low" wrote:


Dear Sir,

I have copied a block of references generated by another business system to
Excel 2002 worksheet.

All the references has 6 trailing spaces immediately after the pasting.

A B
PKHLA050______
PKHLA051______
PKHLA052______
PKHLA054
PKHLA055
PKHLA056
PKHLA057


May I know is there any formula I can enter at B1 and copy down eliminate
the trailing spaces.

I need to do this as VLOOKUP formula does not work with references that
have trailing spaces.


Kind Regards

Low

A36B58K641