Replace when wild cards used

Bud Tripp
Occasional Visitor

In excel, ? matches any single character, thus s?b could be used to find s1b, s2b, and so forth. Once the matching items are found, I would like to leave the value matched by the ? wild card unchanged, let's say, for example, I want s1b to be replaced by s1foo, s2b by s2foo, and so forth. I tried using s?foo as the replacement string, but that literally replaced the digit with the ? character rather than leaving it alone. Is there a character that indicates "no change" to what matched the wildcard?

2 Replies
Hi! Can you post a screenshot of what you mean with that issue „?“, ?
it’s an unknown character while importing content from other file types, such as cab or txt... or is it cleared yet? Greets, Eva

Hi Bud,


To my knowledge Ctrl+H doesn't work such way

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 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
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies