MicrosoftI didn't know that the conversions took place on pasting into the AFE. I had rather assumed that it was the upload from the AFE (English) to the workbook (international localisation) that triggered the conversion.
The use of ¶=CHAR(10) is something of an affectation but, from my days of writing reports using Word, the character was more familiar than CHAR(10)/CHAR(13). I did have to use the regular Name Manager to get Excel to accept ¶ as a Defined Name.
In the formula you show that does the arrangement of hands, the CHOOSECOLS is entirely unnecessary, it just pleased me to lay the hands out in order {"North", "East", "South", "West"} rather than letting WRAPROWS return {"North", "West", "East", "South"}. Since the hands are random, 'who cares?' would not be unreasonable reaction. Necessary or not, the problem does provide some opportunity to demonstrate the value of JoeMcDaid 's new(ish) array-shaping functions!
