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.