Find and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-1726450%22%20slang%3D%22en-US%22%3EFind%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726450%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20%22Find%20and%20replace%22%20for%20an%20entire%20excel%20file%2C%20not%20just%20a%20single%20tab%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1726450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1726490%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813788%22%20target%3D%22_blank%22%3E%40RockHop1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20Replace%20dialog%2C%20click%20'%20Options%20%26gt%3B%26gt%3B'.%3C%2FP%3E%0A%3CP%3ESelect%20Workbook%20from%20the%20Within%20dropdown.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3549.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222905i14EDBB949900DA30%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3549.png%22%20alt%3D%22S3549.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

How do I "Find and replace" for an entire excel file, not just a single tab?

Thanks.

2 Replies
Highlighted

@RockHop1 

In the Replace dialog, click ' Options >>'.

Select Workbook from the Within dropdown.

 

S3549.png

Highlighted

@RockHop1 

 

Find or replace text and numbers on a worksheet

https://support.microsoft.com/en-gb/office/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-...

 

Steps:

Opens the Home tab in Excel.
Click in the toolbar on the right on the button "Search and Select" (magnifying glass / binoculars).
Click on Replace ... in the submenu.
A small search window opens.

 

To replace letters, words or strings of characters:
Enter the content that you want to search for and that is to be replaced under "Search for" above.
At "Replace with" you enter what the search term should be replaced with.
Click on Options to distinguish between upper and lower case, compare entire cell contents, or search the entire workbook instead of the current worksheet.

 

With the "Replace all" button, all character strings found are automatically replaced.
We recommend, however, to work with the Find Next and Replace buttons beforehand in order to first check whether the data has been correctly found and replaced.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.