I was trying to sort my 40000 emails, first downloaded them to an excel – the issue was it had one categoty of email from gmail and yahoo and other category for companies.

Here is the way:

http://www.get-digital-help.com/2009/01/30/how-to-extract-email-addresses-from-a-excel-sheet/

use this formula in a new coloumn –
=INDEX(A1:C1, 1, MIN(IF(ISERROR(SEARCH(“@”, A1:C1)), “”, COLUMN(A1:C1)))) + CTRL + SHIFT + ENTER copied down as far as necessary.

if you want to separate gmail or yahoo – change the search field to @yahoo /@gmail and then use the sort button to sort gmails/yahoo/, one after other etc.

In: Uncategorized Asked By: smadavaram [21 ]