Cell or Range reference operators in Excel
Cell or Range reference operators in Excel are used to combine Ranges or Cell references. Following table shows different Excel reference operators.
| Cell or range reference operators | Description |
|---|---|
| : | Used to create a Range reference from two Cell addresses |
| <space> | Used to create a "Range intersection" from two Range references |
| , | Used to create a "Range union" from two Range references |
Click the following link to know the difference between union and intersection of Excel ranges.