Category: Text
Returns the leftmost characters from a text value
LEFT(text, [num_chars])
Category: Logical
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFERROR(value, value_if_error)
Category: Text
Finds one text value within another (not case-sensitive)
SEARCH(find_text,within_text,[start_num])
Category: Text
Substitutes new text for old text in a text string
SUBSTITUTE(text, old_text, new_text, [instance_num])
Category: Text
Returns the number of characters in a text string
LEN(text)
0
This formula get anything to left of the first space or underscore.