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