Find and replace in excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-2258700%22%20slang%3D%22en-US%22%3EFind%20and%20replace%20in%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2258700%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20search%20and%20replace%20a%20word%20in%20a%20excel%20link%20it%20returns%20%22Not%20Found%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2258700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2258768%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20replace%20in%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2258768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1019318%22%20target%3D%22_blank%22%3E%40gvanderwaltshopritec%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1301480470%22%20id%3D%22toc-hId-1301480476%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90%23ID0EACAAA%3DWeb%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EFind%20or%20replace%20text%20and%20numbers%20on%20a%20worksheet%3C%2FA%3E%3C%2FH1%3E%3CH2%20id%3D%22toc-hId-1992041944%22%20id%3D%22toc-hId-1992041950%22%3EFind%26nbsp%3B%3C%2FH2%3E%3CP%20class%3D%22x-hidden-focus%22%3ETo%20find%20something%2C%20press%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECtrl%2BF%3C%2FSTRONG%3E%2C%20or%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EHome%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEditing%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFind%20%26amp%3B%20Select%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFind%3C%2FSTRONG%3E.%3C%2FP%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%22%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BIn%20the%20following%20example%2C%20we've%20clicked%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%26gt%3B%20Search%20Options%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20show%20the%20entire%20Find%20dialog.%20By%20default%2C%20it%20will%20display%20with%20Search%20Options%20hidden.%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3E%3CSTRONG%3ETips%3A%3C%2FSTRONG%3E%26nbsp%3BYou%20can%20use%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ewildcard%20characters%3C%2FSTRONG%3E%26nbsp%3B%E2%80%94%20question%20mark%20(%3CSTRONG%3E%3F%3C%2FSTRONG%3E)%2C%20asterisk%20(%3CSTRONG%3E*%3C%2FSTRONG%3E)%2C%20tilde%20(%3CSTRONG%3E~%3C%2FSTRONG%3E)%26nbsp%3B%E2%80%94%20in%20your%20search%20criteria.%3C%2FP%3E%3CUL%20class%3D%22ocpAlertSectionListContainer%22%3E%3CLI%3E%3CP%3EUse%20the%20question%20mark%20(%3F)%20to%20find%20any%20single%20character%26nbsp%3B%E2%80%94%20for%20example%2C%20s%3Ft%20finds%20%22sat%22%20and%20%22set%22.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EUse%20the%20asterisk%20(*)%20to%20find%20any%20number%20of%20characters%26nbsp%3B%E2%80%94%20for%20example%2C%20s*d%20finds%20%22sad%22%20and%20%22started%22.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22x-hidden-focus%22%3EUse%20the%20tilde%20(~)%20followed%20by%20%3F%2C%20*%2C%20or%20~%20to%20find%20question%20marks%2C%20asterisks%2C%20or%20other%20tilde%20characters%20%26nbsp%3B%E2%80%94%20for%20example%2C%20fy91~%3F%20finds%20%22fy91%3F%22.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CH2%20id%3D%22toc-hId-184587481%22%20id%3D%22toc-hId-184587487%22%3EReplace%3C%2FH2%3E%3CP%3ETo%20replace%20text%20or%20numbers%2C%20press%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECtrl%2BH%3C%2FSTRONG%3E%2C%20or%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EHome%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEditing%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFind%20%26amp%3B%20Select%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EReplace%3C%2FSTRONG%3E.%3C%2FP%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%20x-hidden-focus%22%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BIn%20the%20following%20example%2C%20we've%20clicked%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%26gt%3B%20Search%20Options%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20show%20the%20entire%20Find%20dialog.%20By%20default%2C%20it%20will%20display%20with%20Search%20Options%20hidden.%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%20x-hidden-focus%22%3E%3CSTRONG%3ETip%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BWhen%20you%20click%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EReplace%20All%3C%2FSTRONG%3E%3CSPAN%3E%2C%20every%20occurrence%20of%20the%20criteria%20that%20you%20are%20searching%20for%20will%20be%20replaced%2C%20while%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EReplace%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bwill%20update%20one%20occurrence%20at%20a%20time.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%20x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--1622866982%22%20id%3D%22toc-hId--1622866976%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90%23ID0EACAAA%3DWeb%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ENeed%20more%3F%3C%2FA%3E%3C%2FH2%3E%3C%2FDIV%3E%3CP%20class%3D%22ocpAlertSection%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20this%20information%20will%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time%20and%20patience%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi there

 

I am trying to search and replace a word in a excel link it returns "Not Found"

 

11 Replies

@gvanderwaltshopritec 

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

@NikolinoDE , that's Excel Online, not sure it works the same way as on desktop version.

Hi Sergei
You are right not the Same, it can't search and replace in Formulas or links
Thanx
Gideon
not the Same, it can't search and replace in Formulas or links
Is in the info / link, for web .... should work ... theoretically.

Can't try it out myself at the moment, rely on what Microsoft said

@gvanderwaltshopritec 

In general it searches within formulas. For example

image.png

after replace

image.png

i have a link to another spreadsheet, and this is where it does not work ?

@gvanderwaltshopritec 

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.

i have a Multiple links Like This
='https://shoprite-my.sharepoint.com/personal/gvanderwalt_shoprite_co_za/Documents/Conf Call SA/Cat Analysis/[Cat Cent Template.xlsx]Summary'!B8
i want to Change the word "Cent" to "Durban" using Find and Replace as there are to many Link on one Page.
Hope that explains it.

@gvanderwaltshopritec 

You are right, that doesn't work. I'll send a frown from Help->Feedback, you may do the same.

@Sergei Baklan Thank you for your Help