Excel 2002 : How to remove trailing spaces ?

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
 
F

Fred Smith

And you don't need the plus sign in the function.

=trim(a1)

will work just as well and looks cleaner.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to remove trailing spaces in cells 2
How do you remove trailing spaces withour Trim function? 8
How keep Leading/Trailing spaces when save in Excel? 0
Excel 2002: How to eliminate empty spaces ? 1
Excel 2002: How to add blank spaces to text and numbers 2
Remove trailing spaces from multiple columns in Excel 8
Excel 2002: How to retain default formating after pasting ? 12
Excel 2002: Any formulas to look up unsorted column ? 1

Top