Split email address by username and email domain

Question

I would like to split the username and email domain from an email address. For Example, test.leo@gmail.com 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_]",""), "@"), "")

rockinfreakshow · Answer 1 · 2023-01-27T18:57:18.190

1

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$",""),))

edited Jan 27 '23 at 18:57

answered Jan 16 '23 at 15:26

rockinfreakshow

15,077
3
12
19

I think it won't work on cases like martin.contreras@gmail.com, am I right? – Martín Jan 16 '23 at 16:02
its testing good for that specific email @Martín – rockinfreakshow Jan 16 '23 at 16:31
You're right, I thought it would work on both members separately – Martín Jan 16 '23 at 17:43

Martín · Answer 2 · 2023-01-16T17:43:02.650

0

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

edited Jan 16 '23 at 17:43

answered Jan 16 '23 at 15:51

Martín

7,849
2
3
13

Split email address by username and email domain

2 Answers2