Thanks Bob, but when I went to the options menu, that was already unchecked.
Any other suggestions?

Thanks for the help.

"Bob I" wrote:

Goto Tools, Options, Transition, UNcheck Transition navigation keys

Lost in Microbiology wrote:

Ron,

Thanks for the reply.

The apostrophe only shows up in the formula bar. When I use the formulas
like: =Left, =Right, or =Mid the apostrophe isn't recognized, so the first
character is omitted.

For example:
The formula bar looks like: '01ES
The cell looks like: 01ES

If I run =Mid(cell, 2, 255) the result is 1ES

Thanks for any help.


"Ron Rosenfeld" wrote:


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