Spreadsheet tool

Excel to Sheets Converter

Paste a formula. Safe function names change automatically, and the rest are flagged for review.

DirectionFormula

=IF(REGEXMATCH(A2,"^INV"),SPLIT(A2,"-"),GROUPBY(B2:B50,C2:C50,SUM))

REGEXTEST: Renamed to REGEXMATCH. Both return TRUE or FALSE. Excel adds an optional case setting.

TEXTSPLIT: Renamed to SPLIT. SPLIT covers column splits. Row delimiters need a different approach.

GROUPBY: Manual change needed. Closest option: QUERY. Rewrite as a select statement with group by.