Excel SCAN Function – Google Sheets Alternative | ComTools

Learn Excel SCAN: what it does, Google Sheets support (Not supported), alternatives (—), and convert formulas online.

What is Excel SCAN?

Returns intermediate REDUCE results.

Google Sheets compatibility

On Google Sheets, SCAN is marked as Not supported.

Convert with ComTools

Paste a formula that uses SCAN into /excel-formula-converter, choose Google Sheets or Excel as the target, and get support status plus suggested rewrites.

FAQ

QDoes Google Sheets support SCAN?

Status: Not supported. Check the suggestion text on this page.

QCan ComTools rewrite my formula automatically?

Simple renames (e.g. TEXTAFTER→REGEXEXTRACT, TEXTSPLIT→SPLIT) and simple LET expansions are attempted; complex formulas get guidance.