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