AnsweredAssumed Answered

Excel design table to grab certain text in a cell.

Question asked by Jason Martin on May 2, 2016
Latest reply on May 2, 2016 by Eusebio García

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.

Outcomes