Truncate e-mail text string at the @ portion in excel

Question

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 :)

Answer 1

Split a email address in half:

Username:

=LEFT(A1,FIND("@",A1)-1)

Domain:

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

...the +/- 1 adds or removes the @ symbol