Below are pics of the pages Im working with and examples in the formula bar.
Replace function in excel opening file dialog box.
I have a copied sheet in my workbook from another page and I need to change all the formulas with a common text replacement. All the formulas from the original page have "MDC" and I need to change it to "CLM". I am using the find/replace command, but when I click replace, it opens a file box and wants me to select the file and does that on every single cell in the new page. See pics. Thanks in advance.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
6 answers
Sort by: Most helpful
-
Anonymous
2020-07-24T21:31:16+00:00