Removing Letters from the Fields in a Column

I have a list of customer sales drawings I need to filter through, but I need to only search for the specific part number, so I would like to create a column with only the part number associated with the sales drawings. For example, say I have the current field of "SD100-1-11" where the part number associated with this sales drawing is "100-1-11". I will need to change all the list of "SDXXX-XX-XX" into a list of "XXX-XX-XX". I assume it will have to be done through VB, but I don't have enough experience with it to do it myself (correctly).
Please help if you know this shortcut.

Thank you.

Hi

You can use

=RIGHT(A1,8)

Do all values in the the field have the same format and same number of characters i.e. AB123-4-56?

You could use =RIGHT(x,len(x)-2). This will remove the first two characters i.e. SD in your example

Great! Kindly mark the thread as 'solved'

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save