Replacing a string in formula that contains quotes

[amalsp]

Hi,

I have a worksheet(s) with a lot of formulas. The formulas are similar to the one below.

=SUMIFS(All_CM[Opening],All_CM[Type],"<>P",All_CM[Old],"N")

Now I want to remove a criteria (first one) from all the formulas. If I try to search and replace it does not work. Is there a way to search and replace with a comma using VBA? The criteria i want to remove is in the middle of the criteria list.

Thanks in Advance

Amal

[chandy123987]

use substitute() function

[jindon]

When you used double quote within a string, you need to escape them by adding another double quote.

Please Login or Register  to view this content.