Always get 1st name (or last)
July 23, 2022
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
You can then have a formula to show it in the format you need.
This one uses an old technique using function ISERROR, since it was created before the formula IFERROR was added to Excel. I bet we can have a better version now 🙂
GoLast to jump to last cell in a column
Fx to cut long column into two columns
Multiple lines in cell using functions
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that