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?

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

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