View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!