At work I receive a messy string of data in the wrong format for how I need it , was wondering if anyone could figure out a formula/formulas to change it.

I receive the data in the following format , where X represents a random letter and 1 is a random number.

XXX/11111.1.1

Just to make mattter worse sometimes the 3 letters at the front is only 2 letters , and the whole sequence is occasionally followed "/[Name]".

The format I need is 11111-0001-1.

For example "ATR/18691.2.7/Bell" , should be "18691-0002-7".

Im not even sure if this is possible however if it is can someone save me as it drives me insanse.

Cheers