How do you find the union and intersection in Excel? Union and Intersect The union operator (comma) adds two ranges. The intersect operator (single space) returns the intersection of two ranges. Excel automatically adds union operators (commas). You can use Read more…