Take A1 and remove “*” located at the end.
=IF(ISERROR(IF(FIND(“,”,A1)>0,A1)),A1,IF(FIND(“,”,A1)>0,IF(ISERROR(FIND(“*”,A1)),A1,LEFT(A1,FIND(“*”,A1)-1))))
If A1 = “Doe, Jane*” it will return “Doe, Jane”
Take A1 and remove “*” located at the end.
=IF(ISERROR(IF(FIND(“,”,A1)>0,A1)),A1,IF(FIND(“,”,A1)>0,IF(ISERROR(FIND(“*”,A1)),A1,LEFT(A1,FIND(“*”,A1)-1))))
If A1 = “Doe, Jane*” it will return “Doe, Jane”
GuruOfComputerWisdom.com 