hi, !

I'm trying to Concatenate an array of cells into 1 cell but there can be anywhere from 0 to 50 entries.
I don't have a problem finding the size of the array
but I've got the array as an offset right now and I'm unsure how to return the text from the array. Any suggestions?

1) could you be more specific regardig "where" (exactly) could it be your "anywhere" ?
and (of course) how to be sure *IF* the array is 0 or 50 entries ?

2) could you expose the formulae and/or code actually used (if any) ?

3) it might be preferable an UDF (but, knowing a little more of your unexposed "details")

regards,
hector.