1

As the title suggests, I need to find and replace two consecutive question marks (??) in my Excel file.

I've tried the solution at: How to search for ? (question mark) in Excel . I tried with ~?? but this also replaces single question marks (?)...

How would I go about it??

Community
  • 1
Joel Min
  • 217

1 Answers1

1

Use ~?~? instead.

The ~ escapes the question mark, telling Excel that you don't want it to use the question mark to represent any letter (see "wildcards in Excel" for example)

enter image description here

Michael Frank
  • 8,091
  • 3
  • 43
  • 54
Code Abominator
  • 148