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
|