SCAN processes arrays row by row and returns cumulative results ... SCAN also handles multistep REGEX operations in a single formula. If you need to extract, validate, and transform text all at once, ...