• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

Excel spreadsheet MS 2010

I have a column that contains names and email addresses. I need a simply way to select just the email addresses and move them to another column, thus isolating the email addresses. Please share the formula to do that.


Thank you!
0
Anthony K O365
Asked:
Anthony K O365
  • 2
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

please provide a data sample. What is actually in the cells?

You may be able to use the Text-To-Columns functionality or a formula, but it really depends on how the data is structured.

cheers, teylyn
0
 
Anthony K O365Author Commented:
Note the sample file attached.
sample.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
If, as the example indicates, the data starts in row 1, then use

=INDEX(A:A,ROW(A1)*2)

copy down as far as required. Copy the results and use Paste Special > Values. Then you can delete the column with the formula.

Or, you could use a formula like

=IF(ISNUMBER(FIND("@",A1)),A1,"")

This will write only the email addresses into a new column and will leave blank cells between them. After copy  and paste as values, you can sort the result to delete the blank cells.
0
 
Anthony K O365Author Commented:
That worked!

Thanks much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now