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.