Copy part of a code within a cell

Hello community!

I'm looking for a formula or workaround for capturing part of a code in a cell and copying it from another cell

In my contract number column I have 91B023047

I would like to copy B023 to another cell by somehow removing 91 and 047. Is this possible somehow?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!