TEXTAFTER
Returns text that occurs after given character or string.
TextModern Excel FunctionsText CleaningText Processing
What it does
Extracts text after a delimiter.
Syntax
TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
Arguments
text(text) — The text to search.delimiter(text) — The delimiter.
Examples
Get Last Name
Extract after space.
FORMULA
=TEXTAFTER("John Doe", " ")RESULT
Doe
SAMPLE DATA
| A | |
|---|---|
| 1 | Name |
| 2 | John Doe |