Merging numbers into a long list separeted by a comma

Copper Contributor

Hello, 

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 

example of data from a typical file: 

40015
40016
40017
40018
3 Replies

@Bubblecup If you use Excel MS365 or 2021, you can use the TEXTJOIN function.

 

@Bubblecup Attached a workbook with two more solutions. PowerQuery and CONCAT

@Riny_van_Eekelen 

 

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