Hi David
Thanks for your help, i've tried your TRIMALL Macro you suggested but unable
to make it work. Error message "THAT NAME NOT VALID" when I run the Macro.
Any further assistance you can give me would be appreciated.

"David McRitchie" wrote:

Hi Dave,

You almost have it the
TRIM Worksheet Function

But you might want to use a macro so that you can make the change
in the column or other selected cells.

As opposed to using a worksheet function, using copy, then paste special, values,
before you can eliminate the original cells.

see the TrimALL macro and notes that go with it in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
More information on installing and using a macro
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave" wrote in message ...
How can I trim the last space from text but leave the other spaces intact
ie:- Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)

Sir Edward Landseer (FR) Sir Edward Landseer (FR)

I've tried =SUBSTITUTE(A1," ","") but this trims all the spaces out.
Any help will be welcomed.