excel - getting a list of numbers into one cell

[stemitch2000]

Hello,
I have got a column of cells, with numbers in them. I would like to generate just one cell with this numbers seperate by a comma. i.e.

10
2
3
4

would end up like

10, 2, 3, 4

This is to go into a comparison table, and nothing to do with CSV - though that is an option.

 

[BerylM]

I think the formula you want is concatenate, for instance:

=CONCATENATE(A1, ", ", A2 ", ", A3 ", ", A4)

would produce 10, 2, 3, 4 if your numbers were in A1 to A4.

HTH

BerylM

 

[KenWright]

Select the cells and run this - It will put the value in A1

Sub Concat()

n = ""
For Each cel In Selection
If n = "" Then
n = n & cel.Value
Else
n = n & "," & cel.Value
End If
Next cel
Range("A1").Value = n

End Sub

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------