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 May 2, 2016 2:38 PM

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.

Re: Excel design table to grab certain text in a cell.

Eusebio García May 2, 2016 3:14 PM (in response to Jason Martin)

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.
Like Show 0 Likes(0)

Actions