How to Search Excel for an Email Address
Specific information can be difficult to find in a Microsoft Excel spreadsheet document, especially if you're not sure exactly what you're looking for. Email addresses can vary wildly in both user name (the part before the "@") and domain (the part after the "@"), which can make finding a specific address tricky. The process becomes easier, however, when you know that the "@" will be the only symbol in any email address you try to look for.
Instructions
-
-
1
Double-click on the document you'd like to search within for an email address. This will open that document in Microsoft Excel on your computer.
-
2
Click the "Home" button.
-
-
3
Click the "Find & Select" button.
-
4
Click the "Find..." menu option.
-
5
Type "@" (without quotes) into the "Find what:" box and click the "Find Next" button. This will search the Excel document for every instance of the "@" symbol. Repeatedly click on the "Find Next" button until the email address you're looking for appears on screen.
-
1