Excel function

[Sathish9102]

JB-9277-2023 I have to increase the value by 1 of 9277 only not 2023 using the drag and drop method in the same cell without any formula. 

Ex. JB-9277-2023

JB-9278-2023

JB-9279-2023

JB-9280-2023

Is it possible to do so? seek your help. 

[#2]

Not in a single step. But you could enter "just" JB-9277 into a cell and drag that down and then use an adjacent column to append the -2023 to it?