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]

thanks very much

You are welcome.