Forum Discussion
Copy and paste results from Find and Replace on Mac
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.
