Using mid Left right

[Rony Bhuiyan]

How will I extract the domain name(like gmail) from the email address which contains several dot. For example: shanti.du.bd@gmail.com. I do want to extract "gmail". how can I do that? Is there any easy way please?
?

 

[MrKowz]

Welcome to the forums!

Something like this?

Excel 2013/2016
	A	B
1	Email	Domain
2	[email]shanti.du.bd@gmail.com[/email]	gmail
3	this.is.a.test@bigdomain.with.more.periods	bigdomain
Sheet1

Cell Formulas
Range	Formula
B2	=LEFT(RIGHT(A2,LEN(A2)-SEARCH("@",A2)),SEARCH(".",RIGHT(A2,LEN(A2)-SEARCH("@",A2)))-1)

 

[SyedUsman]

Also you can use

=MID(A2,SEARCH("@",A2,1)+1,SEARCH(".",A2,SEARCH("@",A2,1))-1-SEARCH("@",A2,1))

 

[panyagak]

Assuming the gmail address is in Cell A1;
Try this

=MID(A1, 14, 5)