I need to produce column C by concatenating A and B.
C must always have 10 alphanumerics.
A always consists of 7 numerics.
B may have different value:
numbers from 1 to 30 should convert to C01 to C30,
letter C followed by a number from 1 to 30 (C1 to C30) should convert to C01
to C30,
letter C followed by a 2 digit number (C01 to C30) no conversion needed,
letter P should convert to PRS,
value ES shold convert to EOS.
What is the fornula to do this?
Thank you.