Automatically fill in sequential numbers that have a prefix and suffix

[charmzf]

Hi all, I am trying to figure out how to quickly fill in my numbers; these numbers have a prefix and suffix. For example, cell A1 has text that says AB-123-CD. Cells B1 through E1 and A2 through E2 should have the same text as cell A1. Then, in cell A3, I want it to say AB-124-CD. Cells B3 through E3 and A4 through E4 should have the same text as cell A3. Is there a formula I can enter so when I change the number in cell A1, the number in cell A3 is the next number in the sequence?

[GC Excel]

Hi and welcome to the forum,

See example attached, using intermediate columns and CONCATENATE formula.