Using IF functions to merge multiple formulas

I have two scenarios that I need help with.   1.  Removing an alpha character from a string that can be at the beginning or the end.  Column B value in this case is R24615 or could be (for example)...