I use MS Excel 2010. I have a list that conains email and non-email address

I used the FIND and MID commands,using the “@” as the midstring but could only sort the fields to the right, truncating the name on the left. Is there a way to give me both halves of the string (full email address) or another way to do it?
Thanks

Edward