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