在excel中的@部分截断电子邮件文本字符串

I have a situation where I have email addresses but I need to extract the url's. For example I have the email address [email protected] and I need to remove all the characters up to and including the @ sign leaving me with the url "acmecompany.com". I'd also like to add the "www" in front of the extracted text. Thanks :)I have a situation where I have email addresses