Truncate email text string in @ section in excel

Question

I have a situation where I have email addresses, but I need to extract the url. For example, I have an email address [e-mail] and I need to delete all the characters before and leave the @ sign, leaving me with the URL “acmecompany.com". I would also like to add "www" in front of the extracted text. Thanks:)

Answer 1

You can use FIND to find the @ sign, then RIGHT and LEN to get the part you need.

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

Answer 2

Divide your email address in half:

Username:

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

Domain:

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

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

Answer 3

To make the URLs valid, you can always set it to ="WWW."&RIGHT(A1,LEN(A1)-FIND("@",A1)+1)

Hot Tip: This is also useful for separating the first and last names in a list, separated by a space or comma, or whatever.