This is great. Thanks Tim. Thanks also Tom for the explanation.

Daniel
__________________
"Tim Zych" a écrit dans le message de
...
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