[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

TEXTBEFORE

This function converts a text string that is a number to a numeric value.

Syntax

TEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

Arguments

This function has these arguments:

Argument

Description

text

[Required] The text you are searching within. Wildcard characters are not allowed. If text is an empty string, Excel returns empty text.

delimiter

[Required] The text that marks the point before which you want to extract.

instance_num

[Optional] The instance of the delimiter after which you want to extract the text. By default, instance_num = 1. A negative number starts searching text from the end.

match_mode

[Optional] Determines whether the text search is case-sensitive. The default is case-sensitive. Enter one of the following:

  • 0      Case sensitive.

  • 1      Case insensitive.

match_end

[Optional] Treats the end of text as a delimiter. By default, the text is an exact match. 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

[Optional] Value returned if no match is found. By default, #N/A is returned.

Examples

TEXTBEFORE(A2,"Red")

TEXTBEFORE(A3,"Red",,FALSE)