Test, validate and match regular expressions
Matches Excel cell references and ranges, optionally qualified with a workbook and sheet prefix such as [Book1.xlsx]Sheet1! or 'My Sheet'!. Supports absolute ($) and relative references, single cells (A1, $B$2), full ranges (A1:B10), column-only ranges (A:C), and row-only ranges (1:10). Useful for parsing or extracting references from spreadsheet formulas, with case-insensitive matching for column letters.