How to find & replace a formula sequence with * in it?

C

creativeops

How do you do a find and replace for a string of a sumproduct formula that
contains one or more *'s?
 
D

Dave Peterson

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 ~.
 
C

creativeops

Oh cool, thanks again Dave!

Dave Peterson said:
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 ~.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top