Forum Discussion

Bejoy1983's avatar
Bejoy1983
Copper Contributor
Sep 03, 2022
Solved

How to increment value in the middle

Hey all,   So I need help in finding out a method to automatically increment a centre value. So for example my value is XXX/0001/2022-23 and the value 001 should increase incrementally.
  • OliverScheurich's avatar
    Sep 03, 2022

    Bejoy1983 

    ="XXX/"&TEXT(ROW(1:1),"0000")&"/2022-23"

    Maybe with this formula.

Resources