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
If you are open to a VBA solution, please find the attached which contains Sheet Change Code on Foglio 2 Sheet Module and a macro on Module1.
On Foglio 2 Sheet, if you change the rate in cell T2 (yellow cell), you will get the desired output in column B.
Dear Subodh_Tiwari_sktneer,
Thank you very much for your answer, I really appreciate it.
Unfortunately, I am not used to VBA and macros, so is there a way I can do it via "basic" formulas without VBAs nor macros?
Thank you very much for your answer, I really appreciate it.
Unfortunately, I am not used to VBA and macros, so is there a way I can do it via "basic" formulas without VBAs nor macros?