Replace Funtion: To replace "?"
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
On Mar 8, 1:10 am, Sweepea wrote:
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!
|