TEXTBEFORE Function Explained
The TEXTBEFORE function in Microsoft Excel returns the text before a specified character in a given text string. It takes two arguments: text (the text string) and character (the character to search for). It returns the text before the specified character, or an empty string if the character is not found.
TEXTBEFORE Function Syntax
TEXTBEFORE(text, delimiter)
- text: The text string from which you want to extract the characters before the delimiter.
- delimiter: The character or characters that separate the text you want to extract from the rest of the text string.