Double quote with Evaluate() not work

[Dossfm0q]

I just try to add Double quote instead of ""O"" but doesn't work

[A1:A2] = Evaluate("IF({1},""O"" & A1:A3 & ""O"" &"",""&SUBSTITUTE(""O"" & B1:B3 & ""O"" ,"","",""O"" & "";""& ""O"" &A1:A3& ""O"" & "",""& ""O"" ))")

 

[sheetspread]

With such errors it's often easier to remove the evaluate("") part, see what string appears on the worksheet, and debug from there.

 

[Paul Ked]

See this post:

https://www.mrexcel.com/forum/excel...imeters-inserted-post4994313.html#post4994313

You could try putting the O in a cell and making ref to that in the formula.