Forum Discussion
Solved
Concatenate elements via formula
Hello everybody! Hope you're great. I have a problem: I am quite new in using Excel, and I am trying to solve it but without useful results. I have a large list of numbers (say e.g. 50) in one ...
Hi LM_95
One way assuming your version of Excel (you did not mention it as asked in Welcome to your Excel discussion space!) has function TEXTJOIN
in B4 and copy down as necessary:
=TEXTJOIN(", ",TRUE,OFFSET(A$4,(ROW()-ROW(A$4))*B$1,,B$1))Your file with the above formula is attached
Hi LM_95
One way assuming your version of Excel (you did not mention it as asked in Welcome to your Excel discussion space!) has function TEXTJOIN
in B4 and copy down as necessary:
=TEXTJOIN(", ",TRUE,OFFSET(A$4,(ROW()-ROW(A$4))*B$1,,B$1))Your file with the above formula is attached
