Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace an asterisk without replacing everything?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace an asterisk without replacing everything?
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace an asterisk without replacing everything?
Use ~* in the replace dialog -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=550483 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace an asterisk without replacing everything?
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
Search and replace | Excel Worksheet Functions | |||
Append Text to Cell Values Using Replace | Excel Discussion (Misc queries) | |||
replace absolute references | Excel Worksheet Functions | |||
Replace Number with Text using Macro | Excel Discussion (Misc queries) |