I'm working with many formulas like the one below, and would like to know if
there is any way of using a "find" and "replace all" function for a formula.
Such as if I wanted to change all the Kabul's to Chicago for example. Or
will I have to do it manually.


=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG")*(S4:S 99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG" )*(T4:T99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG" )*(U4:U99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG" )*(V4:V99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG" )*(W4:W99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG" )*(X4:X99="SE 1.1")))