XOR LX
Well-known Member
- Joined
- Jul 2, 2012
- Messages
- 4,517
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.
<tbody>
</tbody>
Many thanks to you all in advance.
Regards
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