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...
Hi,
Are these fields contain fixed number of digits ??
I mean four digits(0010) like (1234) or may contain more ???
Are these fields contain fixed number of digits ??
I mean four digits(0010) like (1234) or may contain more ???
They do not have fixed digits. And I have to combine the formula already used in A1 to combine all 4 cells information somehow. Thank you!