Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find & replace a formula sequence with * in it?
How do you do a find and replace for a string of a sumproduct formula that
contains one or more *'s? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find & replace a formula sequence with * in it?
If you're looking to find or replace an asterisk, use ~* (tilde asterisk) in the
find what box. An asterisk and questionmark represent wildcards. Use a ~ to tell excel that you really mean that specific character--not a wildcard. Use ~~ to look for a single ~. creativeops wrote: How do you do a find and replace for a string of a sumproduct formula that contains one or more *'s? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find & replace a formula sequence with * in it?
Oh cool, thanks again Dave!
"Dave Peterson" wrote: If you're looking to find or replace an asterisk, use ~* (tilde asterisk) in the find what box. An asterisk and questionmark represent wildcards. Use a ~ to tell excel that you really mean that specific character--not a wildcard. Use ~~ to look for a single ~. creativeops wrote: How do you do a find and replace for a string of a sumproduct formula that contains one or more *'s? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a formul | Excel Discussion (Misc queries) | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
find and replace macro strange behaviour | Excel Discussion (Misc queries) | |||
Find nth occurrence and replace with ":" | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel |