To concatenate several values, the best thing is to install the Morefunc
Add-in:
http://xcell05.free.fr/ click on English pages. Use the MCONCAT
function.

Example:
=MCONCAT(IF(H5:H404=1,A5:A404&" ",""))

It's not easy to concatenate an Array with normal Excel functions or
formulas.

Hope it helped
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390761