How do I replace an asterisk without replacing everything?

[Guest]

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]

Use ~* in the replace dialo

 

[Guest]

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

 

[Guest]

Use Edit > Replace ~* with (blank)

 

[Gord Dibben]

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

~* will replace just the asterisks.


Gord Dibben MS Excel MVP