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