I got an error message saying the syntac was incorrect and that the security
level was set to low to run the macro.

"Gary''s Student" wrote:

Try this small macro:

Sub tic_killer()
Set rr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants, xlTextValues)
For Each r In rr
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub
--
Gary''s Student - gsnu200803


" wrote:

Yes but like everyone else I got the leading apostrophe. I guess I should
export as the CVS files and then save as an xls. file.

Or has anyone come up with a way to get rid of the apostrophe?