CODEWITHSUNDEEP
excel
egg
egg

Reputation: 373

how to extract the ending from an email in Excel

I have a list of emails and I want to extract / separate the endings (.com/.de/.co.uk) in Excel (so I can total the regions etc they come from).

Does someone know a simple way to do this?

Thanks

Upvotes: 0

Views: 100

Answers (1)

ttaaoossuu
ttaaoossuu

Reputation: 7884

Try this (A1 is your cell):

=RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,".","#",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))+1)

Upvotes: 1

Related Questions