Adding Incrementing Numbers to a Formula

  • Greetings,

    So I know the formula of taking the first letter of 2 words: =LEFT(J4,1)&E4 (this calculate the course they will be doing and their gender)

    My complete formula so far is: =(Control!$G$2&"-"&Control!$H$2&LEFT(J4,1)&E4&RIGHT(Control!$B$6,1)), which looks like PKW-APF1

    What I need now is to add incrementing number 001,002,003 etc. (without having to use a helper column)

    In the end it should look like: PKW-APF1001, PKW-APF1002, PKW-APF1003 etc.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!