Array value in one cell?

[GoHK]

Dear All,

I am using offset function and produced an array, out put like {0, 1, 2, 3, 1, 0}
is it possible to put it into one cell? e.g. put it into cell X86, it will show "012310".

To add on, I also need to transform from number to string, if the first value > 0, output A, otherwise output "empty". If 2nd value > 0, output B, otherwise output "empty", etc

Finally X86 will show "BCDE".

many thanks

 

[yogeshmaney]

and how ur deriving that array {0,1,2......}

 

[martindwilson]

using mconcat from the more functions add in is one way =MCONCAT(OFFSET(A1,1,,5))
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html