Here's a column from an excel I'm working on

column A

row1: sdfsdk;;;;;sdkfjsdfk

row2: fklasdfja;;;;;asdfsdafsd;;;;;

row3: sdf;sdfas;;sdfsf;;;;;

row4: sfkd;sdfsdaf;sfdsfds;;

I want to write a formula that will

1) remove last five characters only if all of them are colons, that is,

;;;;;

2) remove all the colons at the end, no matter how many.

For both the formulas, none of the colons in the middle should not be

affected. The length of each row is uncertain.

## Bookmarks