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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prepend cell contents with adjacent cell? 3
how to flip contents inside the cell of an excel? 2
Using Excel to Separate info within a Cell 3
MACRO RUN random percentage and copy of column values 1
Excel Subtracting multiple columns from another column 3
Excel 2010 - Custom Validation - Cell must contain another cells contents 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How to get domain from e-mail 7

Top