The function TEXTBEFORE returns the text string that is before the delimiter character defined.
Syntax:
=Textbefore (Text string, delimiter character, instance)
Text string. Text string or cell that contain the text string that wanted to be extracted
delimiter character. is the character that define the separation of what will be extracted
instance. if the delimiter character repeats more than one, this define what number of instance to be consider as the separation of the string.