Hi Dave,
I think the error "that name is not valid" but I couldn't find what triggers
such an error.

Are you running other macros okay.
What version of Excel.
Did you modify the macro.

If you are using Excel 95 change xlCalculationAutomatic to xlAutomatic


---
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 ...
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.