TEXTBEFORE
Description
Returns the text that occurs before the specified delimiting characters.
Syntax
TEXTBEFORE(
text
, delimiter
,
[instance_num
], [match_mode
],
[match_end
], [if_not_found
]) - text: The text to search. Worksheets doesn't support using wildcard characters in the search.
- delimiter: The text that marks the point before which you want to extract. The function returns the text that's located before (in front of) this text.
- instance_num: The delimiter instance after which you want to extract the text. If you don't specify the argument, the default is 1. If you specify a negative number, the search starts from the end.
- match_mode: Determines whether the text search is case-sensitive. The default is case-sensitive. Optional. Enter one of the following: 0 = case sensitive. 1 = case insensitive.
- match_end: Treats the end of text as a delimiter. By default, the text is an exact match. Optional. Enter the following: 0 = Don't match the delimiter against the end of the text. 1 = Match the delimiter against the end of the text.
- if_not_found: The value to return if the function doesn't find a match. By default,the function returns #N/A.
Example
The example is based on this table. The example function will return a worker's first name,
using the space between the first and last names as the delimiter.
A | B | C | D | E | |
|---|---|---|---|---|---|
1
| Full Name
| First Name
| Last Name
| SS#
| Last 4
|
2
| Logan McNeil | 232-45-7667 | |||
3
| Steve Morgan | 611-33-5576 | |||
4
| Oliver Reynolds | 242-56-9755 | |||
5
| Teresa Serrano | 432-67-1442 |
Formula | Result |
|---|---|
=TEXTBEFORE(A2," ") | Logan
|