excel add in

[drdarren]

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

 

[tj53]

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".

 

[drdarren]

thanks, that is exactly what i needed