Replace Funtion: To replace "?"
 

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!

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!