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