May 24 2022 04:48 AM
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 |
May 24 2022 05:01 AM
@Bubblecup If you use Excel MS365 or 2021, you can use the TEXTJOIN function.
May 24 2022 05:19 AM - edited May 24 2022 05:21 AM
@Bubblecup Attached a workbook with two more solutions. PowerQuery and CONCAT
Jun 02 2022 11:29 PM
Thank you for your suggestion, the solution works well and is a great help when dealing with many numbers.