Converting columns to single strand of text

[sayoung471]

Anyone know how I can take a list of numbers in a column and turn it into a single continuous string of numbers with a comma between each number?

Any help would be appreciated.

 

[pboltonchina]

Assuming your data in A1 to A4 then in A5 use

=A1&", "&A2&", "&A3&", "&A4

 

[shg]

To do it without VBA,

      B ---C--- -------------D-------------
  2   1       1 C2: =B2                    
  3   2 1,2     C3 and down: =C2 & "," & B3
  4   3 1,2,3                              
  5   4 1,2,3,4

 

[Ron Coderre]

It's important to post which version of Excel you are using so we can customize instructions for you .

In Excel 2010:
Depending on how many numbers there are...maybe this way?
With A1:A10 containing the numbers 1 through 10

then...
• B1: =A1&", "
• Copy that formula down through B10
• Select B1:B10
• Home.Copy...Home.Paste.Paste_Values
• Select B1:E10
• Home.Fill.Justify

The end result in cell B1 will be:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10,

Just remove the final comma and you're done.

Is that something you can work with?