Text correction function

Hi All

i have a several SKU which is not standard and need to be corrected,
encloses my work file with expected text inside
and i need a formula to convert the text as per my expectations, a single formula which can correct all original text

thank you
Didien