This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
You can do this kind of thing with column formulae. However, I find it best to use the Recode platform. I suggest that you look at the help documentation. In particular Advanced > Extract Segment.