The Best Web Host!!

Cleaning List of Names in Excel with a formula

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”