View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default A Very stubborn apostrophe that only shows in editing mode and the

The 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 = "'" Then
r.Value = r.Value
End If
Next
End Sub
--
Gary''s Student


"duugg" wrote:


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 "stubborn" apostrophe and
edit/replace ' with "nothing" 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: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=542617