Separators for Vertical and Horizontal Arrays in Non-English-language versions of Excel

[XOR LX]

Hi all,

I have already posted this question here, but am hoping for it to reach as many people as possible, so have reproduced below for the members of this forum who might be able to help.

In English-language versions of Excel, the separators for vertical and horizontal arrays are the semicolon ( and comma (,) respectively.

I am hoping to compile a list which gives the equivalent separators for as many other language versions, together with, if known, the version(s) of Excel to which they are applicable.

If some of you are wanting to help but unsure what these separators are, a simple way to find out is:

Enter =A1:A3 within the formula bar, then highlight the entire formula and press F9. In English-language versions of Excel this would produce (assuming that range is empty):

={0;0;0}

which indicates that the separator for vertical arrays is the semicolon.

Replacing the formula with =A1:C1 and following a similar procedure will give the separator for horizontal arrays. In English-language versions of Excel this would produce:

={0,0,0}

which indicates that the separator for horizontal arrays is the comma.

If I could ask for replies in the below format (I've filled in a couple that I know), I'd be very grateful.

Language Version	Vertical Separator	Horizontal Separator	Applicable To
English	;	,	All
Italian	\	;	Excel 2007 and earlier
Italian	.	\	Excel 2010 and later

<tbody>
</tbody>

Many thanks to you all in advance.

Regards

 

[RoryA]

I know it's a little tedious, but why not just change the regional settings on your computer to the relevant locale and see what happens to the formulas?

FWIW, Italian in 2010 for me uses ; for vertical rather than .

 

[XOR LX]

I know it's a little tedious, but why not just change the regional settings on your computer to the relevant locale and see what happens to the formulas?

Never even considered that as an option. Will give it a go. Thanks!

FWIW, Italian in 2010 for me uses ; for vertical rather than .

Curious!

Regards