Forum Discussion
Cells don't merge properly (Function COMCAT / tekst.samenvoegen)
A product code is a combination of Alphabetic and Number characters For example GB11104005P Each character has a meaning and the total of this code needs to be 11 characters. I have adjusted...
Excel concatenates the stored values of the cells, not the values as displayed in the cells.
D1 contains the number 4, but it is formatted as "00" to display 04.
E1 contains the number 5, but it is formatted as "000" to display 005.
To concatenate formatted values, you can use the TEXT function:
=CONCAT(A1, B1, C1, TEXT(D1, "00"), TEXT(E1, "000"), F1)
=TEKST.SAMENV(A1; B1; C1; TEKST(D1; "00"); TEKST(E1; "000"); F1)
Thank you! saved me a day! / my day 🙂