Apr 07 2021 05:34 AM
Hi there
I am trying to search and replace a word in a excel link it returns "Not Found"
Apr 07 2021 06:15 AM
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?".
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.
I hope that this information will help you.
Thank you for your time and patience
Nikolino
Apr 07 2021 06:19 AM
@NikolinoDE , that's Excel Online, not sure it works the same way as on desktop version.
Apr 07 2021 06:22 AM
Apr 07 2021 06:22 AM
Apr 07 2021 06:23 AM
Apr 07 2021 06:33 AM
Apr 07 2021 06:38 AM
Apr 07 2021 07:00 AM
Link on another worksheet looks like =Sheet2!A1, link on another workbook some URL starts from =https://....
In both cases you may find and replace something in link text, e.g. Sheet2 on Sheet3. You can't replace the value on which you have link, for that you shall change it in the source.
Apr 07 2021 07:05 AM
Apr 07 2021 07:20 AM
You are right, that doesn't work. I'll send a frown from Help->Feedback, you may do the same.