Thanks, Bernd, we appreciate the link to the EVAL function. We will give it
a try.

Nevertheless, we are still a little perplexed. It was our impression,
generally speaking, that functions retrieved the actual cell contents from a
cell reference, in this case an array. So do you have any idea why the
INDEX() function doesn't recognize the contents of the cell reference as an
array for the first argument?

Thanks,
Richard

*****************
"Bernd P" wrote in message
...
Hello,

One solution:
1. Enter into A1:
'{"Right","Wrong"}
2. Press ALT + F11, insert a new macro module and copy EVAL function
from http://www.decisionmodels.com/calcsecretsh.htm
3. Go back to spreadsheet and enter into A2:
=INDEX(EVAL(A1),1,2)

Regards,
Bernd