After you fill the blanks with the formula (as suggested by Haytham Amairah), you may need to replace the formulas with values, because you need to replace one character in the copied (pasted) value.
Do you want to replace one character in the formula or in the result of the formula?
Kindly elaborate and give an example for better clarity. You may also attach a sample file with test data. Your original data is not required in the sample file. You may enter data similar to what you have.