How can I remove text from end part of a excel doc

[pasingh]

Thanks very very much for your help.
I have also posted another question regarding excel. Could you please look into it and help me with that.

Here is link to the question - Delete Zero from Column 2 in Excel