restructure text format

Hi,

Restructure format.png

Column A is the original text and i want to convert it like in Column C.

In order to do that I need to
1) remove wording "NO", for example in cell A2, A3 and A4
2) If the number is single digit then will add "0" to become at least 2 digit number. For example if the number is 1 then will become 01 and A9 will become A09.

Thank you.