Replace function in excel opening file dialog box.

Anonymous
2020-07-23T02:53:32+00:00

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.

0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Anonymous
    2020-07-24T21:31:16+00:00

    Below are pics of the pages Im working with and examples in the formula bar.

    0 comments No comments