Excel 2002 : How to remove trailing spaces ?
 

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

Excel 2002 : How to remove trailing spaces ?
 

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

Excel 2002 : How to remove trailing spaces ?
 

Dear Gary,

Yes, It works by entering formula =TRIM(+A1) at B1.

Many thanks

Low

--
A36B58K641


"Gary''s Student" wrote:

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

Excel 2002 : How to remove trailing spaces ?
 

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

=trim(a1)

will work just as well and looks cleaner.

--
Regards,
Fred


"Mr. Low" wrote in message
...
Dear Gary,

Yes, It works by entering formula =TRIM(+A1) at B1.

Many thanks

Low

--
A36B58K641


"Gary''s Student" wrote:

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

Excel 2002 : How to remove trailing spaces ?
 

Hello Fred,

Thanks for your advice.

Low

--
A36B58K641


"Fred Smith" wrote:

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

=trim(a1)

will work just as well and looks cleaner.

--
Regards,
Fred


"Mr. Low" wrote in message
...
Dear Gary,

Yes, It works by entering formula =TRIM(+A1) at B1.

Many thanks

Low

--
A36B58K641


"Gary''s Student" wrote:

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