I am looking to create a macro to rename cells under the "Severity" column if it reads one or more things to one standardized field to create charts and pivots with. Below is what I would like the cell to display if it reads any of these texts.
If cell displays: "Severity 1 - Critical" OR "S1" = S1
If cell displays: "Severity 2 - Major" OR "S2" = S2
If cell displays: "Severity 3 - Minor" OR "S3" = S3
If cell displays: "Severity 4 - Cosmetic" OR "S4" = S4
If cell displays: "Developer Support" = Developer Support
If the cell is blank, then the cell can remain blank.