Removing spaces at the end of data in cell

[motorcyclemarket]

I would like to remove spaces at the end of my data in excel. For example, in cell A1, I have this text. "Motorcycle Market ". I only want the spacing removed at the end of my text and the spaces always vary. In this case their is 15 spaces. How would I achieve this? Any help would be much appreciated.

Neil Ghuman
www.motorcyclemarket.com

 

[Gary McMaster]

In cell "B1" =TRIM(A1)

Then fill down.

Gary

 

[motorcyclemarket]

Thank you, that is amazing.

Neil Ghuman
www.motorcyclemarket.com