18 Feb 2019

Properly splitting first name and last name in Microsoft excel

First Name
=IFERROR(LEFT($C2;FIND("@";SUBSTITUTE($C2;" ";"@";LEN($C2)-LEN(SUBSTITUTE($C2;" ";"")));1));$C2)

Last Name
=IFERROR(RIGHT($C2;LEN($C2)-FIND("@";SUBSTITUTE($C2;" ";"@";LEN($C2)-LEN(SUBSTITUTE($C2;" ";"")));1));$C2)