ZeroPadding Mixed Number, Text, Number Content in Cell

I have cells containing text such as 100P1, 10P1, 1P1, 100PB10, etc. I would like to pad the leading set of numbers to 3 places and the trailing set of numbers to 3 places by adding leading zeros where needed to each set of numeric characters. Note that the length of the text portion of the string can vary in length.

Can anyone help me by providing a function to accomplish this, or is that beyond the scope of the forum?

Thank you for any help that can be provided!

Hello Sbubendorf,

Will the format always be nAn ? Where n is a number of 1 to 3 digits and A is one or alpha characters?

Sincerely,
Leith Ross