Copy and paste results from Find and Replace on Mac

Copper Contributor

Hello! I need to sort specific emails addresses out of a list in Excel. I used Find to locate them by their @organization and get the results I need. But then I can't do anything with them. I can select all, but can't paste or direct them to another sheet. 


What am I missing? Any help would be much appreciated!!


2 Replies



If you have a new version of Excel, the FILTER function should be able to do what you want. Here's a link that describes in quite a bit of detail how it works.


If you need more assistance, perhaps you could post a mockup of your actual workbook (no real names or addresses) on OneDrive or GoogleDrive, with a link here that grants edit access.

@mathetes Thank you for your help! I eventually figured it out once I had another more experienced set of eyes on it.