reading a text

Question

Hello,

I am working on extracting the data from pdf, but sometimes due to readability issue , text is not captured correctly for eg -

AB12C -> this should be A812C

Rule is - 1st and last letter are always alphabet's and middle 3 are always numbers.

Please help me with the formula so i can put a logic , if middle numbers have B then it is 8 or I then it is 1.

Thank you in advance

Qiu · Answer

@Ekta 
Glad to help. and would appreciate you would also mark my solution as accept.

Ekta · Answer

@Qiu Thanks so much for the workflow

Qiu · Answer

@Ekta 
we can also try this way.

1110-Ekta.yxmd