I'm trying to parse the name out of an email address. Everything I've
seen in the excel groups is just parsing out the email address.

Can someone help me out. Here is an example:



Is in column A1:A400

Result:

myname

in Column C1:C400

Thanks a bunch