Replace Funtion: To replace "?"

[Guest]

I have a spreadsheet with a whole bunch of ? but when I do a replace ? with
blank,
it actually clear everything on the worksheet.

Perhaps ? is the wildcard to replace all with blank, but is there a way just
to replace
any cell with ? with blanks?

Please help!

 

[Pete_UK]

Put the tilde symbol ~ in front of the ? in the Find What box.

Yes it is a wildcard symbol meaning any single character so on its own
you will be replacing any character with a blank.

Hope this helps.

Pete