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)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 13, 2022

denisepoirier 

Is that exact format, i.e in 2022-1-QA-PUB-1-E numbers are always on second and fifth positions, or that could be different?

Resources