convert Excel Cell Value Automatically

[nt_beans]

So I want a formula or macro which automatically changes cell value whenever certain value is entered:
Example
if I enter C in A1 then cell should Automatically change to C-
if I enter KW in A1 then cell should automatically change to KW

so heres the conversion rule:

C changes to C-
W changes to W-
S changes to S-
SM changes to 06
BO changes to 07
KW changes to KW ( No Change )

Thanks in advance

 

[Joe4]

Why did you post this question again when I was already helping you over here?
https://www.mrexcel.com/forum/excel-questions/1035079-convert-excel-cell-value-automatically.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).