excel add in

Discussion in 'Mac Apps and Mac App Store' started by drdarren, May 29, 2009.

  1. drdarren macrumors newbie

    Joined:
    Aug 10, 2007
    #1
    Hi all, i need to extract email addresses from an excel spreadsheet that all have a common word, such as "health" in their email address. can excel do that or are there any add-ins or programs which will allow me to do that. i prefer freeware but i will pay for it if it is necessary. i am using excel 2008 for mac

    thanks

    darren
     
  2. tj53 macrumors member

    Joined:
    Dec 10, 2004
    Location:
    New Hampshire
    #2
    Select the column you want (emails) and use the Menu to navigate to Data --> Filter --> Auto Filter

    Then click the header row and select "Custom Filter..." and set the method to "Contains" and type in "health". You'll be left with a filtered list of all the emails containing the word "health".
     
  3. drdarren thread starter macrumors newbie

    Joined:
    Aug 10, 2007

Share This Page