Function note

Empty text gives #N/A from TEXTBEFORE and TEXTAFTER, #VALUE! from TEXTSPLIT

FUNC.TEXTAFTER · FUNC.TEXTBEFORE · FUNC.TEXTSPLIT

FN-TEXTSPLIT-001: Empty text gives #N/A from TEXTBEFORE and TEXTAFTER, #VALUE! from TEXTSPLIT

Quirk · measured · recorded 2026-11-04

An empty string as text gives #N/A (delimiter not found) from TEXTBEFORE and TEXTAFTER, but #VALUE! from TEXTSPLIT.

Call and input routeInputsExcelCorrect valueRecorded in
=TEXTBEFORE("","-")
formula-literal		As typed#N/A—Excel build not recorded in this run; bulk captures of the same date (2026-09-29) record Excel 16.0 build 20430, Windows 64-bit, workbook compatibility 2
=TEXTAFTER("","-")
formula-literal		As typed#N/A—Excel build not recorded in this run; bulk captures of the same date (2026-09-29) record Excel 16.0 build 20430, Windows 64-bit, workbook compatibility 2
=TEXTSPLIT("",",")
formula-literal		As typed#VALUE!—Excel build not recorded in this run; bulk captures of the same date (2026-09-29) record Excel 16.0 build 20430, Windows 64-bit, workbook compatibility 2

Basis: Three recorded readings, with blank-cell and logical companions in the same run.

Evidence and capture sources

Machine-readable note records