TEXTBEFORE

Unsupported (not recognized)

Category: Text · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	No	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=TEXTBEFORE("a-b-c","-") on LibreOffice Calc returned #NAME?, but the documented/expected result is a. MISMATCH vs expected: expected 'a', got '#NAME?'
=TEXTBEFORE("a-b-c","-",2) on LibreOffice Calc returned #NAME?, but the documented/expected result is a-b. MISMATCH vs expected: expected 'a-b', got '#NAME?'
=TEXTBEFORE("abc","-") on LibreOffice Calc returned #NAME?, but the documented/expected result is #N/A. MISMATCH vs expected: expected '#N/A', got '#NAME?'
=TEXTBEFORE("abc","-","none") on LibreOffice Calc returned #NAME?, but the documented/expected result is none. MISMATCH vs expected: expected 'none', got '#NAME?'
=TEXTBEFORE("a-b-c","-",-1) on LibreOffice Calc returned #NAME?, but the documented/expected result is a-b. -1 means the last delimiter; text before it is 'a-b'; MISMATCH vs expected: expected 'a-b', got '#NAME?'

Formula	Description	Result	Expected	Verdict
=TEXTBEFORE("a-b-c","-")	Text before the first delimiter occurrence	#NAME?	a	Mismatch
=TEXTBEFORE("a-b-c","-",2)	instance_num=2 counts to the 2nd delimiter	#NAME?	a-b	Mismatch
=TEXTBEFORE("abc","-")	Delimiter not present and no if_not_found -> #N/A	#NAME?	#N/A	Mismatch
=TEXTBEFORE("abc","-","none")	Delimiter not present with if_not_found supplied	#NAME?	none	Mismatch
=TEXTBEFORE("a-b-c","-",-1)	Negative instance_num counts delimiters from the end	#NAME?	a-b -1 means the last delimiter; text before it is 'a-b'	Mismatch