Creating a Marco to Replace a Specific Number with a Specific Letter in a Column

@Waterserv the attached below is the expected results.

@Tigeravatar ... can I change the Columns ("C") to ("C","D") to reflect the change to both columns at once??

Thank you both for your help with this... I know this question is probably very novice.