Search code examples
excelemailexcel-2008

Excel Email Database Replace function

I have an Excel database of email addresses and names. I need to extract the domain name from the email address, and put it into a new column.

i.e: 

col a: joeschmoe@email.com
col b: www.email.com

Where col a is what I currently have, and col b is my goal. I basically need to delete anything at and before the @ symbol, and replace with www..

Is there any way I can do this in Excel in an automated process? I am using Excel 2008 for Mac.

Solution

  • put this in column B1 and drag all the way down:

    ="www." & MID(A1,FIND("@",A1)+1,LEN(A1))