Remove comma (,) from the end of a cell

[niladri20052006]

Hi I want to remove comma (,) from the end of a cell but not from the middle. For example

123 park place, suite 200
145 long avenue,

I want the result as :

123 park place, suite 200
145 long avenue

Is there any one to help me out from this problem?

Thanks in advance!

 

[JackDanIce]

Try this formula:

=IF(RIGHT(A1,1)=",",LEFT(A1,LEN(C361)-1),A1)

 

[MrKowz]

This question has been answered in the OP's first post:

http://www.mrexcel.com/forum/showthread.php?t=534701