Where I work we receive an Outlook address  book from another site to
import into ours for a consolidated address book. Unfortunately the
file we recieve has "junk" in with the email  addresses. Since it is
in .csv/excel format, I'm trying to help
sort it out for the folks to do the importing.. no spammer email
address harvesting issue here.

Anyway, when I tried your formula, I get an error #VALUE.. trying to
figure out why... but this looks like it might be promising.