Solved

Excel spreadsheet MS 2010

Posted on 2013-01-16
4
198 Views
Last Modified: 2013-01-16
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
Comment
Question by:K Anthony O365
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 38784494
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
 

Author Comment

by:K Anthony O365
ID: 38785297
Note the sample file attached.
sample.xlsx
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 38785329
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
 

Author Closing Comment

by:K Anthony O365
ID: 38785350
That worked!

Thanks much
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question