Excel 2002 : How to remove trailing spaces ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
And you don't need the plus sign in the function.

=trim(a1)

will work just as well and looks cleaner.
 
Back
Top