[Solved] How To Automatically Generate Invoice Number In Excel? [closed]

by


If you are willing to be limited to a maximum of three letters for the company name, you can use a formula:

=CONCATENATE(LEFT(B3,1),MID(B3,FIND(" ",B3)+1,1),IFERROR(MID(B3,FIND(" ",B3,FIND(" ",B3)+1)+1,1),""),TEXT(H3,"DDMMYY"))

1

solved How To Automatically Generate Invoice Number In Excel? [closed]