Wednesday, April 09, 2014

Split E-mail Address in Half in Excel

Username: (before '@' sign)
=LEFT(A1,FIND("@",A1)-1)

Domain: (after the '@' sign)
=RIGHT(A1,LEN(A1)-FIND("@",A1)+1)

...the +/- 1 adds or removes the @ symbol

1 comment:

owen said...

Need a competent hacker, i would be kind enough to let you know about the one who is currently working on a project of mine. Finally, after so many trials with different people.

WEBSITE chief-exec.wixsite.com/cryptech
MAIL: CHIEF-EXEC@MANAGEMENTPORTAL.BIZ
Tel: +1 424 264 0575