• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • 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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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