Home

Tilde not working to replace asterisk?

%3CLINGO-SUB%20id%3D%22lingo-sub-555230%22%20slang%3D%22en-US%22%3ETilde%20not%20working%20to%20replace%20asterisk%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555230%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20sure%20if%20using%20the%20tilde%20followed%20by%20the%20asterisk%20no%20longer%20works%20to%20find%20and%20replace%20the%20asterisk%2C%20or%20if%20I%20have%20something%20set%20weird.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20pretty%20sure%20I've%20always%20used%20~*%20when%20wanting%20to%20find%20and%20replace%20an%20*%20but%20now%20Excel%20gives%20the%20error%20that%20%22There's%20a%20problem%20with%20this%20formula%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20another%20easy%20way%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-555230%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Easterisk%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReplace%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etilde%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555716%22%20slang%3D%22en-US%22%3ERe%3A%20Tilde%20not%20working%20to%20replace%20asterisk%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339460%22%20target%3D%22_blank%22%3E%40dmharris%3C%2FA%3E%26nbsp%3B%20Can%20you%20post%20your%20formula%3F%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555901%22%20slang%3D%22en-US%22%3ERe%3A%20Tilde%20not%20working%20to%20replace%20asterisk%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555901%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20just%20talking%20about%20the%20Find%20and%20Replace%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20change%20the%20%22*%22%20in%20every%20selected%20cell%20temporarily%20to%20%22ast%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555903%22%20slang%3D%22en-US%22%3ERe%3A%20Tilde%20not%20working%20to%20replace%20asterisk%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555903%22%20slang%3D%22en-US%22%3E%3CP%3EActually%20that%20answered%20the%20question%20haha%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20to%20change%20the%20%22%3D%22%20to%20%22eql%22%20first%20so%20it%20wasnt%20trying%20to%20make%20it%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
dmharris
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?

 

Thanks!

3 Replies
Highlighted

@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.

 

Thanks!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies