With A1:C1 containing these values
This formula rebuilds the text string you are looking for:![]()
20091130 80928102 EUR
In the above example, the formula returns:![]()
D1: =A1&REPT("0",31-SUMPRODUCT(LEN(A1:C1)))&B1&C1
Is that something you can work with?![]()
2009113000000000000080928102EUR
Bookmarks