software

I have an apostrophe in several cells that only shows when each cell is
double clicked on (bringing it into editing mode).

I have hundreds of cells with this quot;stubbornquot; apostrophe and
edit/replace ' with quot;nothingquot; doesn't see it. Again, it only shows up
when double clicked on and no other time. This data was imported from a
Mainframe application. Is there anything that a mainframe would export
that looks like an apostrophe but is not one and makes it stay hidden
in the cell until it is either double clicked on or viewed from the
formula bar?

Thanks in advance--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=542617This is a common problem- look at this post from Dave Peterson for a
solution:
groups.google.com/group/micro...15 da40bf621bThe leading apostrophe should be visible in the formula bar. It is a
different way of making material text than formatting the cell as text. If
you for any reason, dis-like these single quotes and want to remove them then
try:

Sub dont_quote_me()
Dim r As Range
For Each r In ActiveSheet.UsedRange
If r.PrefixCharacter = quot;'quot; Then
r.Value = r.Value
End If
Next
End Sub
--
Gary''s Studentquot;duuggquot; wrote:

gt;
gt; I have an apostrophe in several cells that only shows when each cell is
gt; double clicked on (bringing it into editing mode).
gt;
gt; I have hundreds of cells with this quot;stubbornquot; apostrophe and
gt; edit/replace ' with quot;nothingquot; doesn't see it. Again, it only shows up
gt; when double clicked on and no other time. This data was imported from a
gt; Mainframe application. Is there anything that a mainframe would export
gt; that looks like an apostrophe but is not one and makes it stay hidden
gt; in the cell until it is either double clicked on or viewed from the
gt; formula bar?
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=542617
gt;
gt;

A simpler method would be to enter a 1 into an empty cell. Copy that cell.
Then select your range of data to quot;fixquot;. Select quot;Paste Specialquot;, and check
the box for quot;Multiplyquot;. This will remove all leading apostrophes. You can
then delete the 1 that you origianlly entered.

HTH,
Elkarquot;Dave Oquot; wrote:

gt; This is a common problem- look at this post from Dave Peterson for a
gt; solution:
gt; groups.google.com/group/micro...15 da40bf621b
gt;
gt;


That worked like a charm! My Wednesday has been made!

As grateful as I am that others give me macros/formulas, I don't know
what to do with them.

Actually, as I know I'll have to deal with using formula(s) like the
ones listed above your post, what do I do with them?

I literally mean, step by step.

For example:

After copying the formula, where exactly do I paste it to?
Do the cells have to be highlighted?
How do I quot;runquot; it?
Is there a quot;play formulaquot; button?

I realize for you experts, execution of formulas you provide may be
second nature to you, but for us quot;programming newbiesquot; it's not that
simple.

Thanks everyone.--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=542617