SPACE Operator ( ) - Excel
Overview
The Space operator ( ) in Excel is a useful tool for creating a union of ranges, allowing you to reference non-contiguous cells or ranges within a formula or function. The Space operator allows for flexibility in referencing multiple ranges within a single formula.
Syntax:
=range_1 range_2 ...range_n