|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.