Forum Discussion

denisepoirier's avatar
denisepoirier
Copper Contributor
Jul 13, 2022
Solved

Getting concat function to insert a specified number of digits

I am working on a Document Registry and each Document will be assigned a 3 digit number starting at 001. I have formatted the cell so it shows as a 3 digit number but when I use the concat function t...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jul 13, 2022

    denisepoirier 

     

     

    in H1:

    =CONCAT(TEXT(DATE(A1,B1,1),"yyyy-mm"), "-", C1, "-", D1, "-", TEXT(E1,"000"), "-", F1)

    if you run a recent version of Excel, in J1:

    =TEXTJOIN("-",,TEXT(DATE(A1,B1,1),"yyyy-mm"), C1:D1, TEXT(E1,"000"), F1)
denisepoirier's avatar
denisepoirier
Copper Contributor
Jul 13, 2022
This is great!!! And it worked!!! Thank you so much, haha, there are not enough excel experts and platforms out there for support and this is so much appreciated!
Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 13, 2022
Glad someone could help + Thanks for providing feedack
For next time(s): don't forget Excel version + Windows/MacOS

Resources