i don't know if there is any direct function for this....
i suggest you to use VBA..

Function Concate(x)
For Each b In x.Cells
a = a & b & ", "
Next
Concate = Left(a, Len(a) - 1)
End Function

just type in B1:
=Concate(a1:a700)


"barbierim" wrote:


OK I have zipcodes in column A (a1-a700) and I would like to put all
into B1 separated by a ",".

so that B1 will have 700 zipcodes all separated by a comma

what's the formula?

Gracias in advance
Mark


--
barbierim
------------------------------------------------------------------------
barbierim's Profile: http://www.excelforum.com/member.php...o&userid=28381
View this thread: http://www.excelforum.com/showthread...hreadid=479689