Stripping out extra "straight quote" character

[Guest]

On occasion an extra character, appearing as a straight quote, occupies the
first space of an entry. Iin fact, I have to double click on the cell in
order for it to appear at all.

The search function does not find this hidden character, and so can't easily
delete them, leaving me with a very tedious manual, cell-by-cell deletion.
Our thinking is that Excel created these as a default character to indicate a
text entry but not sure. How can we delete these in one fell swoop. Is this
possible? I've tried selecting all and bringing text into MS Word in order to
edit there but this straight quote (') character doesn't appear there either.
Any ideas?

 

[Dana DeLouis]

As a first step, see if you have the following option turned on.
Tools | Options | Transition Tab,
and remove the check on "Transition navigation keys."

HTH

 

[Frank Kabel]

Hi
try the following macro:
sub convert_it()
with selection
..value=.value
end with
end sub

 

[Guest]

I see Tools in the main nav bar however don't see Options link under Tools
(Tools | Options | Transition Tab)

My workstation info: Mac OS X, Microsoft Excel X for Mac Service Release 1

Were else might I be looking?

 

[RagDyer]

If you're lucky enough to have this problem exist in columns, you can
alleviate the situation by simply opening and closing "Text To Columns".

Select a column containing the "bad" data.
You can include the "good" with the "bad", since nothing "bad" will happen
to the "good" ( say whaaat !).

While everything is *still* selected:

<Data> <TextToColumns> <Finish>.

And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I see Tools in the main nav bar however don't see Options link under Tools
(Tools | Options | Transition Tab)

My workstation info: Mac OS X, Microsoft Excel X for Mac Service Release 1

Were else might I be looking?