|
Posted to microsoft.public.excel.misc
|
|
|
parse name from email address
=LEFT(A1,FIND("@",A1)-1)
" wrote:
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
|