Excel TEXTBEFORE Function – Google Sheets Alternative | ComTools

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

What is Excel TEXTBEFORE?

Returns text before a delimiter (Excel 365).

Google Sheets compatibility

On Google Sheets, TEXTBEFORE is marked as Not supported. Use REGEXEXTRACT in Google Sheets. TEXTBEFORE(A1,"-") ≈ REGEXEXTRACT(A1,"^(.*?)-")

Convert with ComTools

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

FAQ

QDoes Google Sheets support TEXTBEFORE?

Status: Not supported. Common alternative: REGEXEXTRACT.

QCan ComTools rewrite my formula automatically?

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