copy part of cell contents to another column

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I have an Excel sheet in which one of the columns contains e-mail addresses.

I'd like to add a new column that contains the domain portion of the e-mail
address (so basically anything after the @ sign), and keep the original
column in tact.

Is this possible? If so how?

Thanks!!
 
If the addresses start in A2, put this in the new column:
=MID(A2, SEARCH("@", A2)+1, 999)
 
Back
Top