Need to create a excel formula to clean email addresses

Need to create a formula of when i have an row that have multiple email address, i just need one, wondering how to search .com and everything after that get rid off. If you can help with me with that would be great! Cheers