There are two other methods to use the MID function. Method one is to click the fx button on the top left of the Excel spreadsheet. An Insert Function dialog box will pop up. In the Select a ...

While there are already such functions like SEARCH, FIND, LEFT, RIGHT, MID, and SEQUENCE ... on a key value. OFFSET function ...

Hope something here helps you. Read: How to use the MID and MIDB function in Excel.