Replace "_" with "." and remove Trailing Alpha (where and when applicable)

Hey Guys

I have a desired condition to replace "_" to "." and to have the A,B be removed where applicable.


114_3-F-XXX-1586 -- 114.3-F-XXX-1586
114_3-F-XXX-1586A -- 114.3-F-XXX-1586
114_3-F-XXX-1586B -- 114.3-F-XXX-1586
1067-F-XXX-1000 -- 1067-F-XXX-1000
1067-F-XXX-1000A -- 1067-F-XXX-1000
1067-F-XXX-1000B -- 1067-F-XXX-1000
88_9-F-XXX-1586 -- 88.9-F-XXX-1586


suggestions
Cheers

Is it always just A or B, or could it be a C D E etc?

If it's always just A or B, try

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"_","."),"A --"," --"),"B --"," --")

first of thanks for the reply,..

SUBSTITUTE(A1,"_",".") works... but

There could be A --Z and within that cell there could be a combination of other Letters but don't want to change them.. only the ending..

After the - there will be 4 digits or 5 (5 digit would have the alpha I would like to remove)

Try

=SUBSTITUTE(IF(ISERROR(MID(A1,FIND("--",A1)-2,1)+0),REPLACE(A1,FIND("--",A1)-2,1,""),A1),"_",".")