Next time I will read the whole question before I answer it. The formula in
C1 should be =B1 & "," & B2 & "," & B3. You could then copy this formula to
C4.

Tom

"Anthony" wrote:

I am trying to get a formula to put the values from a list together into one
cell, but the length of the lists are all different lengths and styles. Here
are two examples of the lists I'm dealing with and what I'm trying to do:

A B C
1 AZ2_MO 5-12
2 -7
3 -8
4 AZ3A 01
5 02
6 03
7 04
8 05
9 06
10 07
11 08
12 09
13 10
14 11
15 97
16 -7
17 -8

In cell C1 I would like to have the value: 5-12,-7,-8
In cell C4 I would like to have the value: 01-11,97,-7,-8


Thanks for any help! This discussion board has taught me more than I ever
thought there was to know about excel, and I find I learn something new every
day!