Forum Discussion
Solved
Fill with the help of formula
Hello Everyone, In below screenshot, i want to fill data in NEW CODE column. And Blue arrow line shows for put data with decimal with the help of formula like - Same for NEW DESC Gr...
As variant
=TEXTJOIN(".", 1, TEXT(C3, "##"), TEXT(E3, "00"), TEXT(G3, "000"), TEXT(I3, "0000") ) =TEXTJOIN(".", 1, D3, F3, H3, J3 )but it's not clear which logic shall be if some codes are missed.
As variant
=TEXTJOIN(".", 1, TEXT(C3, "##"), TEXT(E3, "00"), TEXT(G3, "000"), TEXT(I3, "0000") )
=TEXTJOIN(".", 1, D3, F3, H3, J3 )but it's not clear which logic shall be if some codes are missed.
Thank you so much sir.
Excel , you are welcome