excel add in

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

  1. drdarren macrumors newbie

    Aug 10, 2007
    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


  2. tj53 macrumors member

    Dec 10, 2004
    New Hampshire
    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

    Aug 10, 2007

Share This Page