In some Excel files, both native and those created with data imported from a
tab delimited file, many or all of the cells are populated with the ' (as is)
character. This presents a problem when I would like to have cells formatted
in a specific manner (i.e. dates/double integer). I have tried to
search/replace for the character to no avail. Does anyone have a surefire
way of removing this "exact" character enmasse?

Thanks,
Don