View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Can you delete all asterisks in a sheet?

yeah, I realized that once I saw Gord's posting. Goes to show you that given
bad test data, even the worst solution may APPEAR to work great.

"Dave Peterson" wrote:

And yours did get rid of all the asterisks, too. It may have done a bit more
<vbg, too!

JLatham wrote:

Hey, mine worked in my special case (just * entered into a few cells). Oh
well....

"Gord Dibben" wrote:


Congrats.

You are the only responder who got it right<g


Gord

On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student
wrote:


Use Find/Replace

Find
~*

Replace with nothing

.


--

Dave Peterson
.