Does anyone know if there's a union operator in Excel 2010?
I have tried ;
and ,
, neither of them seems to work. For instance, =E2:E3;E4:E6
, =E2:E3,E4:E6
, {=E2:E3;E4:E6}
and {=E2:E3,E4:E6}
always return an error.
Does anyone know if there's a union operator in Excel 2010? I have tried 


Excel's 'union' operator has always been the comma* (e.g. Here are some that do:
However, when you think about it, the *Some Euroversions use the semicolon ( (Further reading: Microsoft Office: Calculation operators and precedence) 


If you want to sum values, you can write this:
If you want to merge texts, you can write this (or use your mouse as @soandos says):
It looks like you want to write 


The question is not too clear, but for now, it seems like you have to merge texts. So for instance – as per your example if you have to union E2, E3, E4, E5, E6 you can write a formula like:
I tried it myself: You have to individually describe cells. ":" This is not working for me too in Concatenate. So you should try as explained above. Else, mmdemirbas's answer perfectly explains the 


In short the answer is NO. However, for some functions you can use the following workaround,
Note that the ranges have one cell in common (ie intersecting). The "," is used by some functions to allow multiple range to be provided as parameter. This is not a union as this will include the intersection cell twice. It will be COUNTED TWICE. So, by subtracting the intersection you get the correct answer. This technique should work with the following:
It won't work with:
The formula can be modified to work with:
It is never required with It's a real pain that it works like this and that there is no UNION operator. In VBA you can write a function that create a proper union: see here for info http://www.cpearson.com/excel/BetterUnion.aspx ie


