TRIM Formula - Remove Comma from value in cell

[hrayani]

Hi All,

I need a formula to remove commas from a cell...

Sample Data

123, 456, 567,,,,,, required answer 123, 456, 567
990,256,, reqiured answer 990,256
12567, 308211, required answer 12567, 308211

I want all commas to be removed which are at the end of the cell value

Any help would be appreciated

Regards,

Humayun

 

[steve the fish]

Looking at yours i dont actually think it works properly.