help me to change part Number automatically 1

[nguyenthanhcong]

Hi everybody.
I have some parts with part number such as:

XXX-YYY-ZZZ-ab ( for example HIA-123-456-01)
with ab = 01->49

I want to change 2 last letters of part number as :

XXX-YYY-ZZZ-cd with cd = ab+50
forexample : HIA-123-456-01 -> HIA-123-456-51

Can you help me to write a macro?
thankyou very much

 

[cilici]

newpartnumber = left(oldpartnumber,len(oldpartnumber)-2) & cstr(cint(right(oldpartnumber,2))+50)

didn't test it, should be fine.

 

[nguyenthanhcong]

thankyou verymuch.
it's working fine