copy part of cell contents to another column

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!!
 
T

tedmi

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