Extract company name from email address with multiple values after @

[candymycandy]

Hi,

I have a formula that extracts the domain/company name from an email address after the @ sign when the format is BobSmith@Company.com
=MID(LEFT(D748,FIND(".",D748,FIND("@",D748))-1),FIND("@",D748)+1,99)

Is it possible to do this to extract the domain/company when the email address is in the format BobSmith@UK.Company.com please?

Thanks in advance for any help!

 

[candymycandy]

How about

Fluff.xlsm
	A	B
1
2	BobSmith@Company.com	Company
3	BobSmith@UK.Company.com	Company
4	BobSmith@UK.Company.co.uk	Company
5	BobSmith@Company.co.uk	Company
6	BobSmith@ab.co.uk	ab
7	BobSmith@ab.com	com
Lists

Cell Formulas
Range	Formula
B2:B7	B2	=LET(s,TEXTSPLIT(TEXTAFTER(A2,"@"),"."),TAKE(FILTER(s,LEN(s)=MAX(LEN(s))),,1))

But you are going to have problems with companies that only have 2 letters.

I can work around the 2 letters thing as there aren't going to be too many like that. Thank you this has done it!

Thanks all.

 

[Fluff]

Glad we could help & thanks for the feedback.