Delete Spaces at the end of text in a cell

[deepakgoyal2005]

I have a series of data in a column of an excel sheet with spaces at end.
I need a formula to delete the spaces at end only.
I tried with TRIM function but it deletes spaces in beginning of text as well, which is not required.
Please Help !!!

 

[Scott Huish]

I'm not sure how we revived a 3 year old thread, but although it needs a correction, my intent was to maintain the leading spaces and get rid of the trailing ones, to comply with the request of the original post.

I tried with TRIM function but it deletes spaces in beginning of text as well, which is not required.

It should be this though:
=LEFT(A1,FIND(TRIM(A1),A1)+LEN(TRIM(A1))-1)