Hi,

Try the =clean(cell ref.) formula in a helper column.

Jaleel

"SeanF74" wrote:

I have a spreadsheet where columns D through N have SOME data with
apostrophies before the data (e.g., '777, 'DCH8, 'GlobalExpress). Some data
does, and some data doesn't have the apostrophe and they are all mixed
together. This becomes a pain when trying to compare cells (e.g., I want to
compare replace DCH8 with 'DCH8). When I go to find replace, if I put find '
and replace with nothing, it does not find anything. How can I get rid of
all of the ' in front of the data?

Thanks!