formula to extract names before the domain list of emails

[kiran5]

Hi All,

Happy to post again to learn something new here

I have a list of email ids in A column like below:
Kiran.kumar@xyz.com
kiran.kumar@xyz.co.nz
kiran@abc.com
kiran@exm.com.au
kumar5@example.co.au

I have this list of domains like .com, .co.au etc in another sheet of d same workbook. This will be added as soon as we find a new domain.
Now I need the name just before the domain in B column.
output for the above should be:
xyz
xyz
abc
exm
example

Any help would be great.

Thanks heaps

 

[azumi]

Maybe

=MID(A1,FIND("@",A1)+1,LEN(A1)-FIND("@",A1)-4)

 

[azumi]

Im missed something, try this...

=MID(MID(A1,FIND("@",A1)+1,255),1,FIND(".",MID(A1,FIND("@",A1)+2,255)))