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 🙂
