Apostrophes in formula bar

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

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
 
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
 
Back
Top