See the screenshot below for the MID function in this example. Cell A2 is referenced for the Text argument because it contains the Product Number from which we want to extract information. The number ...

For example, type "=MID (A1, 25, 4)" to extract the substring that begins at position 25 and has four characters Provide the word you want to identify as part of your formula and use the FIND and ...