Replacing a string using find

[marvinsae]

So I've highlighted my cells for where I want to replace a string in my if statement with another string.

for example,

=SUMIFS($I$3:$I$27,$E$3:$E$27,"*blue*8*",$F$3:$F$27,"<"&DATE(2017,1,1),$G$3:$G$27,">="&DATE(2016,12,1))



so i use alt+f and look up "*blue*8*" and replace it with "*white*8*" but it's not replacing the formula properly.

I'm guessing it has to do with the wildcards?

How would I write this out so it actually works?

 

[Scott Huish]

ALT-F? Usually find and replace is CTRL-H.

But in the find box, put
~*blue~*8~*
and in replace:
*white*8*

 

[marvinsae]

that worked perfectly. What does the ~ do anyways? thanks

 

[63falcondude]

that worked perfectly. What does the ~ do anyways? thanks

"*" is a wildcard so the "~" tells excel to search for that character and not to see it as a wildcard.