Use this code;

Sub RemoveIt()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants, xlTextValues)
.Value = .Value
End With
End Sub



--
Regards
Dave Hawley
www.ozgrid.com
"Suz771" wrote in message
...
I have a spreadsheet where all the fields (except those with numbers) have
a
' before the data in the cell. The ' does not show up in the cell, but
only
in the formula line. CTRL+H does not work, nor does it work using the ~
with
the ' (either before or after the ' character).

I need to remove this character in order for my formulas to work. The
spreadsheet has over 10K rows and 170 columns.

Thank you,
Susie