Always get 1st name (or last) ANmar Formulas - combined functions / IF / ISERROR / LEFT / Len / Logical / RIGHT / SEARCH / Standard functions / Texts and Strings / TRIM IF / ISERROR / LEFT / LEN / RIGHT / Search / TRIM July 23, 2022 July 19, 2022 Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.