Home > Back-end >  Excel find and replace causing issues with range criteria in formula
Excel find and replace causing issues with range criteria in formula

Time:11-25

Currently I have a workbook that has thousands of formulas in it. When I created the sheet there was an unknown variable that was yet to be decided upon.

So I chose to place (,"**",) in the formulas with an aim to return and replace this with the variable once it was known with a mass find and replace.

Here's where the issue is. Now when I try to run the find and replace function (I want to change ,"**", to "<>") it not only changes the ,**, but all other criteria's for the formulas as well, breaking the formulas.

I've tried finding and replacing variations such as (,"**",) but I still have the same issue.

If there isn't a work around I can manually trawl through the thousands of formulas and update them but if I do this I may not see the sun this side of Christmas. PLEASE HELP!

CodePudding user response:

Just as the * character is used as a wildcard character in an Excel formula, it's also a wildcard in the find/replace function.

To search for a literal asterisk in Excel, you can prefix it with a tilde: ~*

More information: Using wildcard characters in searches

  • Related