copy into one cell

[Siegfrid15]

Hi,

I have ona question. You are much more experienced in VBA.
How to copy some number, each number in other row from one column into one cell and separate them with comma?
12
13
14
15
16

should be in one cell: 12, 13, 14, 15, 16

Many thanks for your help!!!!
Thanks

[alansidman]

Assume data is in cells A1:A5. In B1 type =A1 & ", " & A2 & ", " & A3 & ", " & A4 & ", " & A5

Note the space after the comma

[protonLeah]

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.