Forum Discussion

Sathish9102's avatar
Sathish9102
Copper Contributor
Feb 26, 2024

Excel function

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. 

Excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 26, 2024
    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?

Resources