May 09 2019 12:30 PM
I'm not sure if using the tilde followed by the asterisk no longer works to find and replace the asterisk, or if I have something set weird.
I am pretty sure I've always used ~* when wanting to find and replace an * but now Excel gives the error that "There's a problem with this formula".
Is there another easy way to do it?
Thanks!
May 09 2019 01:56 PM
@dmharris Can you post your formula?
May 09 2019 02:59 PM
I'm just talking about the Find and Replace
I want to change the "*" in every selected cell temporarily to "ast".
May 09 2019 03:00 PM
Actually that answered the question haha
I had to change the "=" to "eql" first so it wasnt trying to make it a formula.
Thanks!