1 Reply Latest reply on May 2, 2016 3:14 PM by Eusebio García

    Excel design table to grab certain text in a cell.

    Jason Martin

      I am looking to use excel to grab text in one cell and use that info for another cell.

      For example. My part number would be 12-3-4567-89-01. I am looking to use the numbers 89-01. The numbers would always be the same in all part numbers since the "89" represents the size and the 01 represents the material type. Is there a way to use excel to this advantage in a way that whatever number it starts with, it just adds the "89-01" to the end of it. These are a lot of parts and it becomes very time consuming.