Forum Discussion
gvanderwaltshopritec
Apr 07, 2021Copper Contributor
Find and replace in excel online
Hi there
I am trying to search and replace a word in a excel link it returns "Not Found"
11 Replies
Sort By
- NikolinoDEGold Contributor
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
- gvanderwaltshopritecCopper Contributornot the Same, it can't search and replace in Formulas or links
NikolinoDE , that's Excel Online, not sure it works the same way as on desktop version.
- NikolinoDEGold ContributorIs in the info / link, for web .... should work ... theoretically.
Can't try it out myself at the moment, rely on what Microsoft said 🙂