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 ...
Hi again HansVogelaar. Another quick question please. What will be the formula if I want the number to go down instead? for example 03-L-046-A, 03-L-046-B, and then 03-L-045-A, 03-L-045-B etc.
Many thanks
Many thanks
With just A an B, that would be
=LEFT(A1,5)&TEXT(MID(A1,6,3)-(RIGHT(A1)="B"),"000")&"-"&CHAR(65+MOD(CODE(RIGHT(A1)),2))