Excel: Combine every 10 cells into another cell then…


Hi everybody, new here. I need a macro that takes e.g. every 10 cells from let’s say column A (the length of column A varies from time to time so I don’t have a fix end) and combine the characters from those cells into one string which is comma separated and paste that into a single cell. Ideally the width of the receiving cell/column then should be a bit wider than standard like ~ 100. The width is not so important if that is complicated to do. Here an example to illustrate:

A C D
1224 Chunk 1: 1224, 2345, 2345, 3452
2345 Chunk 2: 5634, 1224, 2345, 2435
2345 Chunk 3: and so on
3452 Chunk 4: and so on
5634 so on
1224
2345
2435
3452
5634
1224
2345
2345
3452
5634
1224
2345
2345
3452
5634
end unknown
Any help is appreciated. Thanks.


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of May 11, 2017.


For more resources for Microsoft Excel