Sorting data

G

Guest

I have a large amount of data in an Excel sheet. In the
midst of this are many email addresses, which I somehow
need to separate from the rest of the text. Is there any
automatic way to do this? I can go through manually and
cut out the mail addresses, but this is very time
consuming.
 
F

Frank Kabel

Hi
this depends on the type/structure of your data. If
there#re for example some delimiters this can be achieved.
You may provide some example values of your data
 
D

David McRitchie

Hi <[email protected]>,
This really looks like a misworded subject, but I
will assume you want something to do with sorting
besides the question you asked.

You can extract hyperlinks from the
cells -- though for email it might be the same (?).
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress

So for something to sort on:
After extracting them say you wanted to sort on the domain name
=IF(ISERROR(FIND("@",D2)),"",MID(D2,FIND("@",D2)+1,99))
you can double click on the fill handle to copy down as long as
the cell to the left is not empty.
http://www.mvps.org/dmcritchie/excel/fillhand.htm

How do you expect to find your answers after a few days if you
don't use your name (first and last). Most of use our names
plus our email addresses so we can find what we posted and
get our replies. It's also a lot more friendly.
 
Top