| 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 | |||
Linear Mode
