Tilde not working to replace asterisk?

New Contributor

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?



3 Replies

@dmharris  Can you post your formula?

I'm just talking about the Find and Replace


I want to change the "*" in every selected cell temporarily to "ast".


Actually that answered the question haha


I had to change the "=" to "eql" first so it wasnt trying to make it a formula.



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies