On Tue, 8 May 2007 07:06:01 -0700, Lost in Microbiology
wrote:

I am using Monarch to find specific data from a report and exporting into
Excel for analysis. However, every field has an apostrophe added in front of
the cell contents. To make it worse, Excel doesn't recognize it, I tried
doing a find and replace, but it didn't find an apostrophe anywhere. I did a
=right(cell, #,#) which works for many of the fields, but the name field is a
variable length. It may seem trivial, but it is affecting how the data is
stored so I can't format or sort the fields correctly.

Does the apostrophe show up only in the formula bar? Or does it also show in
the cell?

If the former, it is merely a text qualifier.

If the latter, you should be able to get rid of it by using a formula such as

=MID(cell,2,255)


--ron