Remove Last Comma

[pinkgemini]

Hi There,
I'm doing data clean up for a client & have run across data that contains a comma at the end. They've supplied it to me this way & from what I can see it just ends (there is no space after the final comma) IE:

Cheerful, Chipper, Convivial, Delighted, Ecstatic, Elated, Exultant, Pleasant, Pleased, Sparkling, Sunny, Tranquil, Unadorned, Symphony,

The next row may be similar in descriptors but not contain the extraneous comma at the end. IE:

Compassionate, Tender, Calm, Countrified, Priestly, Tranquil, Unadorned, Symphony, Pastoral

Is there a way to remove the final comma in the fields where it's just "dangling" at the end but not remove it from the fields that don't contain the extraneous comma?

Obviously Find & Replace doesn't work because I need the commas to remain throughout the rest of the data. I've searched the boards & have not found a formula that works...if I've missed something that's already posted I apologize. I'm going a bit cross eyed at the moment & with thousands of rows to go through, I'd hate to have to remove the ending comma's one at a time!

Many thanks,
pinkgemini

 

[THAuzhavan]

Sorry for the delayed reply. After a break, i am coming to cotribute for my wikimedia projects. Thanks for your guidelines. One more ?, is it possible to remove 2charecters at the end of the data and also 3charecters, at the begining of the data. For example, if a column contains #[[data]] , i want only data. how can i remove #[[ ]]. Thanks in advance.

 

[THAuzhavan]

Finally,one of my friend guided me. Raw data in columnA (e.g. #[[data]]). The data with the changes in column B (e.g. data) .The formula is =mid(A1,4,len(A1)-5) Bye! friends!!