Use the ConcatAll UDF from Tigeravatar, available here:

http://www.excelforum.com/tips-and-t...geravatar.html

Scroll down to get the latest version.

Hope this helps.

Pete