Excel vs Google Sheets: TEXTBEFORE Compatibility | ComTools
Compare TEXTBEFORE on Excel (Supported) vs Google Sheets (Not supported). Alternatives and free conversion.
Side-by-side support
Excel: Supported. Google Sheets: Not supported. Sheets alternative: REGEXEXTRACT. Excel alternative: —.
Migration tip
Use REGEXEXTRACT in Google Sheets. TEXTBEFORE(A1,"-") ≈ REGEXEXTRACT(A1,"^(.*?)-")
Convert now
Use /excel-formula-converter?fn=textbefore to paste a formula containing TEXTBEFORE.
FAQ
QCan I use TEXTBEFORE on both platforms?
Not fully. Use the alternatives listed above or the online converter for suggestions.