Forum Discussion
Find and replace in excel online
Find or replace text and numbers on a worksheet
Find
To find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.
Note: In the following example, we've clicked > Search Options to show the entire Find dialog. By default, it will display with Search Options hidden.
Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.
Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".
Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".
Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".
Replace
To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.
Note: In the following example, we've clicked > Search Options to show the entire Find dialog. By default, it will display with Search Options hidden.
Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.
Need more?
I hope that this information will help you.
Thank you for your time and patience
Nikolino
