Forum Discussion
Excel Formula - stringing cells with Concatenate-Len in 1 cell
Utilizing Excel 2016 - I need to string together 4 cells in a column. Cell A1 =CONCATENATE(LEN(D1),”:”,LEN(C1),”:”,LEN(B1)) Cell B1 XA Cell C1 0010 Cell D1 HELUA662 I need 4 cells to be comb...
You can use this formula to get the desired result in Cell A1
=CONCATENATE(D1,TEXT(C1,"0000"),B1)
=CONCATENATE(D1,TEXT(C1,"0000"),B1)