Forum Discussion
Mr_Peters
Oct 16, 2021Copper Contributor
Issue with Find & Replace feature - can only find and replace with in formulas not values
Hi there, I face a strange error in excel within the find and replace feature. I cannot select values to find and replace. Pre-selected is formulas and I cannot change it - cannot select any oth...
HansVogelaar
Oct 16, 2021MVP
In the Find tab of the Find and Replace dialog (1. in the screenshot), you can select Formulas, Values or Comments. But in the Replace tab (2. in the screenshot), you can only select Formulas.
For cells that contain fixed values, the effect is the same as if you could select Values.
But for cells that contain formulas, it would not make sense to be able to select Values: the value of such a cell is a result of the formula, you cannot replace it with something else.
skylar630
Jun 27, 2023Copper Contributor
HansVogelaar This doesn't work. Microsoft has so many open ended unsolved issues it's frightening.