list values from multiple cells in one cell separated by linebreaks

Hi,

I would like to list values from an array of cells into one cell separated by a new line

example
years are given in column a
(a1,a2,a3) = (2002, 2004, 2008)

I would like to show all three years in cell b1. ie
b1 = a1 (linebreak) a2 (line break) a3

displayed as
b1= 2002 (linebreak) 2004 (line break) 2008


I know I can do this by
b1 = a1 & CHAR(10) & a2 & CHAR(10) & a3

But I would like to display the years by giving the start reference and the end reference ie. cell a1:a3

The reason for this necessity is that the number of years in each cell varies, ie. 3 rows in cell b1, 2 rows in cell b2 etc.

Figured that might happen - Lost myself a couple of times explaining.

Yes thats right, I want to add the start and end point and have excell list the data from that range in one cel.

I've uploaded a picture showing a simplified version of what I need

find it here:
http://tinypic.com/r/jpg2fl/6

Hi Tom,

Not sure how to go about this. I guess it's for use in Visual Basic?

okay. Thank you. I'll look into that