You can also use the following formula to remove the trailing space:

=TRIM(A1)

Copy down the column as far as necessary, then copy the entire column with
the formula and do a EDIT/PASTE SPECIAL/VALUES over the original data.

You can then remove the helper column w/the TRIM function.
--
Kevin Backmann


"Jarek Kujawa" wrote:

2. presuming yr data starts in A1 (in some other column) use the
formula:
=LEFT(A1,LEN(A1)-1)
to get rid of spaces in the end, then copy and paste special as values

HIH