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.