How do I replace an asterisk without replacing everything?

Trw · 06-09-2006, 05:25 PM

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?

**mrice** · 06-09-2006, 05:43 PM

Use ~* in the replace dialog

SimonCC · 06-09-2006, 05:50 PM

If you don't have any asterisk in any of your original non-blank cells, you
can do Find and Replace again by using ~* in the Find what field. But if you
have asterisk in your original data, those would be replaced as well.

-Simon

"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?

Allllen · 06-09-2006, 05:50 PM

Use Edit > Replace ~* with (blank)
--
Allllen

"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?

Gord Dibben · 06-09-2006, 06:00 PM

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 <[email protected]> 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?