Merging numbers into a long list separeted by a comma

Question

Hello,&nbsp;I'm working with article numbers in different systems and in one system I need to put in article numbers separated by a comma. The problem is that it could be quite long lists with 50+ cells in excel and very time-consuming. For example, I need to take the numbers in the cells and transform them into the following format 40015, 40016, 40017, etc., and copy-paste them into another system to run the numbers. How could I merge these figures and separate them with a comma?Help with this would be very appreciated&nbsp;example of data from a typical file:&nbsp;40015400164001740018

riny_van_eekelen · Answer

Bubblecup&nbsp;If you use Excel MS365 or 2021, you can use the TEXTJOIN function.&nbsp;

riny_van_eekelen · Answer

Bubblecup&nbsp;Attached a workbook with two more solutions. PowerQuery and CONCAT

bubblecup · Answer

Riny_van_Eekelen&nbsp;&nbsp;Thank you for your suggestion, the solution works well and is a great help when dealing with many numbers.&nbsp;

Forum Discussion

Merging numbers into a long list separeted by a comma

Share

Resources