Forum Discussion

GTS's avatar
GTS
Copper Contributor
Mar 05, 2023
Solved

Avoid Breaking formulas While Searching and Replacing

How can I easily search and replace a group of cells containing similar formulas without breaking the formula and getting an error.  Sometimes it's an easy substitution, but other times you have to m...
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Mar 11, 2023

    GTS 

    Try this.

    First replace = with ##.

    Then make your custom replaces.

    And then replace ## with =.

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 11, 2023

GTS 

Try this.

First replace = with ##.

Then make your custom replaces.

And then replace ## with =.

 

  • GTS's avatar
    GTS
    Copper Contributor
    Mar 11, 2023
    Thank you! Your suggestion worked perfect.

Resources