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.