i) In column A is my product series as "18-65-85", "18-1-98", "18-656-74" and
etc.
Now, I would like make it all in standard as "18-0065-85", "18-0001-98"
"18-065
6-74" and etc. What's faster way?

ii)Now in column B is my product code as "PO-484P", "PP-65P", "HB-K5P", etc.
Now, I would like to add an "A" in every code to be "APO-484P",
"APP-65P", "AHB-
K5P", etc... What's faster way?