To search for text or numbers in Excel, you can use the Find & Select feature. Here are the steps:
1. Click the Find & Select icon in the Editing group on the Home menu.
2. Click Find. The Find and Replace dialog box appears.
3. Type in the word or phrase you want to find and click Find.
4. Excel will highlight the matches on the spreadsheet.
You can also use wildcard characters to search for partial matches or variations of the word or phrase.
If you want to find the position of a character in a given text string, you can use either the SEARCH or FIND function. Here are the steps:
1. Write the SEARCH function as shown below:
`= SEARCH (“b”, “My Ball”)`
2. As the first argument, write the character to be found enclosed in quotation marks.
3. Write in the text string from where the character’s position is to be found.
If you want to learn more about Excel functions and how to use them, Microsoft Support offers video training and other resources.
