I thought this be trivial but I'm just not finding the right solution.
I have a column of cell entries where there are occasion input errors for the non-numerical portion of the values. So, I want to automatically correct these errors.
Input value / Corrected input value)
C005 / C005 (already correct)
CT021 / C021
044 / C044
33 / C033
In other words, the correct value is always going to be in the format, "Cxxx". Where xxx = 000 - 999. The leading zeros are important.