Excel: =SWITCH function to recode

This video provides an example of how to use =SWITCH to do just that, switch the coding of a field. You might be interested in taking a text/string field and converted to a numeric value or a numeric value to text. The video uses example data from the ATS with incident success as an outcome that is recoded a couple different ways.