Forum Discussion
Excel
Hello, I want increase the last digit of a cell containing various numbers by 1 after every four roles. For example, 03-L-056-A, 03-L-056-B 03-L-056-C ...
Let's say the first value is in cell A1.
Enter the following formula in A2, then fill down.
=LEFT(A1,5)&TEXT(MID(A1,6,3)+(RIGHT(A1)="D"),"000")&"-"&CHAR(65+MOD(CODE(RIGHT(A1)),4))
HansVogelaar , Thank you so much. It worked and has saved me an immense amount of time.