Excel function

Copper Contributor

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





Is it possible to do so? seek your help. 

1 Reply
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?