Split email address by username and email domain-CodePudding

I would like to split the username and email domain from an email address. For Example, [email protected] to test.leo and **gmail ** without .com

Formula used: =IFERROR(SPLIT(REGEXREPLACE(INDEX(Filter!$A:$AY,MATCH($A39,Filter!$A:$A,0),MATCH(N$1,Filter!$1:$1,0)), "\[a-zA-Z0-9_]",""), "@"), "")

CodePudding user response：

tested on couple of email address varieties here. you may test it out extensively on your whole data set & see how it goes...

=INDEX(IF(LEN(A2:A),REGEXREPLACE(REGEXEXTRACT(A2:A,"^(.*)@(.*)\."),".co$",""),))

CodePudding user response：

You can try also with this option:

=INDEX(IF(ISEMAIL(A2:A),REGEXEXTRACT(A2:A,"(. )@(. ?)."),))

If you need only to remove the last ".***" Just remove the interrogation mark