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.
You can use the "right" command to return as many characters from the end of string. For example if A1 contained, 12-3-4567-89-01 and in A2 contained =right(A1,5), the value returned in A2 will be 89-01 (5 characters from the end of the string).
You can also use "left" if you want to return a string from the beginning.