View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_4_] Tim Zych[_4_] is offline
external usenet poster
 
Posts: 58
Default Find and replace '

Not if the apostrophe is the prefix character. To get around it use VBA:

Sub RemApos()
Dim rngArea As Range
For Each rngArea In ActiveSheet.Cells. _
SpecialCells(xlCellTypeConstants).Areas
rngArea.Value = rngArea.Value
Next
End Sub


"Daniel" wrote in message
...
Hello, is there a way to search for the apostrophe (') character with the
Find button?

Thanks