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...
- I am sorry Detlef Lewin,
But this will not include the leading zeros..
Thats what Pamela Concepcion asked for.. 🙂The green arrow on the left top corner in the image represents Text Formatting..
In the formula I gave I have added it in case of other format...For reference..http://The%20green arrow on the left top corner in the image represents Text Formatting.. In the formula I gave I have added it in case of other format....
Also read the comment at the end of the page by chris.
