View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How do I replace an asterisk without replacing everything?

Use a tilde along with the asterisk in the "replace what" dialog box.

~* will replace just the asterisks.


Gord Dibben MS Excel MVP

On Fri, 9 Jun 2006 14:18:03 -0700, Trw wrote:

I have used an asterisk to replace blank cells in order to import into
another application (minitab). How do I undo this replacement without
replacing everthing else?