how do I get data from an array into one cell (comma delimited)
 

looking for a way to query an array 3 cells by 3 cells (they have numeric
data only) and return a value in a seperate cell that has all the numbers in
the array (comma delimited)
thanks

how do I get data from an array into one cell (comma delimited)
 

If C1 thru E3 contain:

1 2 3
4 5 6
7 8 9

then:

=C1 & "," & D1 &","& E1 &","& C2 &","& D2 &","& E2 &","& C3 &","& D3 &","& E3

will return:
1,2,3,4,5,6,7,8,9

--
Gary's Student


"bb" wrote:

looking for a way to query an array 3 cells by 3 cells (they have numeric
data only) and return a value in a seperate cell that has all the numbers in
the array (comma delimited)
thanks