Specifying ranges of columns

You specify a range of columns by nominating the first and last column reference of the range, separated by a hyphen, with or without intervening spaces. You can optionally enclose the range in parentheses.

These are valid ranges of columns:

#17-#19
#17 - #19
(#17-#19)
(#17 - #19)
To specify more than one range of columns:
  • Enclose each column range in parentheses (optionally separated by commas), or
  • Separate each column range with commas, but without any intervening spaces.

These are valid ranges of columns:

(#8-#11) (#17-#19) (#24-#25)
(#8-#11),(#17-#19),(#24-#25)
#8-#11,#17-#19,#24-#25

These are invalid ranges of columns:

#8-#11 #17-#19 #24-#25
#8-#11, #17-#19, #24-#25
Note:
  1. Column ranges can overlap. For example, #2-#7, #5-#9. In this case, the result is a consolidated single column range equivalent to #2-#9.

Related references