Hey Eric,
Thanks for the suggestion. Clever use of Right and Left together like that - I was stuck on using Mid.
The formula you provided works sometimes, but not all the time. It looks like the formula starts backwards at the end of the string and then pulls text whenever it comes across /either/ a "S" or a "5" rather than the two together. For example, here's part of a sentence I have:
"S5775: To return blah blah blah blah
Should use 0, 2, 5, or 8"
The formula outputs: "R4, o" so it seems the whole string "S5" in the left/right part of the formula isn't being respected and it is simply pulling everything after it finds "5". The same thing occurs with a sentence that contains a capital "S".
