Data from CRMs and exports is almost always "dirty": extra spaces, phone numbers in different formats. Text functions clean it up.
TRIM(text) | removes spaces at the ends and double spaces inside |
SUBSTITUTE(text, old, new) | replaces a fragment; "" deletes it. For several characters, nest the functions |
LEFT(text, n) | the first n characters (see also RIGHT, MID) |
SEARCH(find, within) | position of a fragment, case-insensitive; #VALUE! if not found |
TEXTJOIN(delimiter, ignore_empty, …) | joins values with a delimiter; by hand: =A2&", "&B2 |
Tricks: =ISNUMBER(SEARCH("urgent", C2)) — does the text contain a word (TRUE/FALSE); =LEFT(A2, SEARCH(" ", A2)-1) — the first word.