Contact
12 programs
Explore the site

TEXTAFTER Function (LibreOffice Calc)

Text Intermediate LibreOffice Calc LibreOffice 25.8

The TEXTAFTER function in LibreOffice Calc extracts text that appears after a specified delimiter. It supports instance selection, case sensitivity options, and default return values, making it a modern and powerful text-extraction tool.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: LibreOffice 25.8.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.

Version compatibility: TEXTAFTER became available in LibreOffice Calc 25.8. It is not available in Calc 25.2 or older releases. See the official LibreOffice 25.8 release notes and function reference.

The **TEXTAFTER** function extracts text that appears after a specified delimiter in LibreOffice Calc. It supports selecting which occurrence to use, optional case sensitivity, and default return values. TEXTAFTER is a modern, powerful replacement for complex FIND/SEARCH/MID formulas traditionally used for delimiter-based extraction.

What the TEXTAFTER Function Does

  • Extracts text after a delimiter
  • Supports selecting the Nth occurrence
  • Supports case-sensitive or insensitive matching
  • Allows a default value if the delimiter is missing
  • Works with text, numbers (converted to text), and formulas

It is designed to be clean, modern, and extremely flexible.

Syntax

TEXTAFTER(text; delimiter; [instance]; [match_mode]; [match_end]; [if_not_found])

Arguments

  • text:
    The text to extract from.

  • delimiter:
    The text or pattern to search for.

  • instance: (optional)
    Which occurrence to use (default = 1).

    • 1 → first occurrence
    • 2 → second occurrence
    • -1 → last occurrence
    • -2 → second-last occurrence

  • match_mode: (optional)

    • 0 → case-sensitive (default)
    • 1 → case-insensitive

  • match_end: (optional)

    • 0 → delimiter must be fully matched (default)
    • 1 → match delimiter at end of text

  • if_not_found: (optional)
    Value to return if delimiter is missing (default = #N/A).

Basic Examples

Extract text after the first hyphen

=TEXTAFTER("A-B-C"; "-")

Returns "B-C".

Extract text after the second hyphen

=TEXTAFTER("A-B-C"; "-"; 2)

Returns "C".

Extract text after the last hyphen

=TEXTAFTER("A-B-C"; "-"; -1)

Returns "C".

Case-insensitive extraction

=TEXTAFTER("HelloWORLD"; "world"; 1; 1)

Returns "" (empty string after the delimiter).

Provide a default value if delimiter missing

=TEXTAFTER("ABC"; "-"; 1; 0; 0; "Not found")

Returns "Not found".

Advanced Examples

Extract file extension

=TEXTAFTER(A1; "."; -1)

Extract domain from email

=TEXTAFTER(A1; "@")

Extract everything after the first space

=TEXTAFTER(A1; " ")

Extract everything after the second space

=TEXTAFTER(A1; " "; 2)

Extract text after a long delimiter

=TEXTAFTER(A1; " - ")

Extract after a dynamic delimiter

=TEXTAFTER(A1; B1)

Extract after a delimiter only if present

=TEXTAFTER(A1; "-"; 1; 0; 0; A1)

Extract after a delimiter in CSV-like text

=TEXTAFTER(A1; ","; 1)

Extract after the last slash in a file path

=TEXTAFTER(A1; "/"; -1)

Extract after a substring ignoring case

=TEXTAFTER(A1; B1; 1; 1)

Extract after a delimiter that appears many times

=TEXTAFTER(A1; "|"; 5)

Extract after a delimiter at end of string

=TEXTAFTER("ABC-"; "-"; 1; 0; 1)

Returns "".

Edge Cases and Behavior Details

Missing delimiter → #N/A unless if_not_found provided

=TEXTAFTER("ABC"; "-") → #N/A

instance < 0 counts from the end

=TEXTAFTER("A-B-C-D"; "-"; -2) → "C-D"

instance too large → #N/A

=TEXTAFTER("A-B"; "-"; 5) → #N/A

match_mode controls case sensitivity

=TEXTAFTER("ABCdef"; "DEF"; 1; 1) → ""

match_end allows matching delimiter at end

=TEXTAFTER("ABC-"; "-"; 1; 0; 1) → ""

text is a number → converted to text

=TEXTAFTER(2024; "2") → "024"

delimiter is empty → Err:502

text is empty → returns empty string

TEXTAFTER of an error propagates the error

=TEXTAFTER(#N/A; "-") → #N/A

Common Errors and Fixes

#N/A — Delimiter not found

Fix:
Provide an if_not_found value.

Err:502 — Invalid argument

Occurs when:

  • delimiter is empty
  • instance is non-numeric
  • match_mode invalid

Unexpected extraction

Cause:

  • Case sensitivity mismatch
  • Wrong instance number
  • Hidden characters in delimiter

Fix:
Use CLEAN, TRIM, or SUBSTITUTE.

Best Practices

  • Use TEXTAFTER instead of FIND/SEARCH/MID chains
  • Use negative instance values to extract from the end
  • Use match_mode for case-insensitive extraction
  • Always provide if_not_found for robust formulas
  • Combine with TEXTBEFORE for full delimiter-based parsing
  • Use TRIM and CLEAN before extraction for reliability
TEXTAFTER is your modern extraction engine — perfect for clean, readable, and robust delimiter-based parsing without the complexity of legacy formulas.
  • Use TEXTBEFORE to extract text before a delimiter
  • Use SEARCH or FIND for positional extraction
  • Use MID, LEFT, RIGHT for manual parsing
  • Use SPLIT (future Calc versions) for array-based splitting
  • Use SUBSTITUTE for targeted cleanup

By mastering TEXTAFTER and its companion functions, you can build powerful, modern, and highly readable text‑processing workflows in LibreOffice Calc.