Removing prefix on email address to leave company name in field

Hi,

I have a question regarding deletion and replacement in a new field.

ie. A1 reads dave.jones@microsoft.com
I want A2 to read microsoft

What is the code to delete "dave.jones@" and ".com" to be revealed in a new field.

Cheers.

Try:

=MID(A1,FIND("@",A1)+1,FIND(".com",A1)-FIND("@",A1)-1)

or if it is not always .com at the end...

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

it could be something like martin.wilson@fred.co.uk
so try
=LEFT(MID(A1,FIND("@",A1)+1,20),FIND(".",MID(A1,FIND("@",A1)+1,20))-1)