How To Use The Union And Intersect Operator In Excel2020-1-31Range Union and IntersectThis example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.