TEXTAFTER

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)

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

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