Careful about double posting...

Use the StringConcat() function available he
http://www.cpearson.com/excel/stringconcatenation.aspx

Steps and instructions to use it were given to you in your other message he
http://www.microsoft.com/communities...r=US&sloc=&p=1

--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Dylan @ UAFC" wrote:

I have 1000 rows. I need a formula that can
combine all the data in these rows into a single
cell, data seperted by , and then space.