code: public static function splitRange($pRange)
      {
          // Ensure $pRange is a valid range
          if (empty($pRange)) {
              $pRange = self::DEFAULT_RANGE;
          }
  
          $exploded = explode(',', $pRange);
          $counter = count($exploded);
          for ($i = 0; $i < $counter; ++$i) {
              $exploded[$i] = explode(':', $exploded[$i]);
          }
  
          return $exploded;
      }
docs: Split range into coordinate strings.
  
  @param string $pRange e.g. 'B4:D9' or 'B4:D9,H2:O11' or 'B4'
  
  @return array Array containing one or more arrays containing one or two coordinate strings
  e.g. ['B4','D9'] or [['B4','D9'], ['H2','O11']]
  or ['B4']