Joanne,

Select all your cells, and run this macro

Sub PutValues()
Set myRange = Intersect(Selection, ActiveSheet.UsedRange)
myRange.Value = myRange.Value
End Sub

HTH,
Bernie
MS Excel MVP


"Joanne" wrote in message ...
I have been given a worksheet with hunderds of rows and a couple dozen
columns.
All the data entry has been preceeded by an apostrophe in the formula
input bar. I tried find/replace, but it does not see the apostrophes.
Could someone please tell me how to do a global erasure of these
apostrophes throughout the entire worksheet?
Thanks so much for you help
Joanne