Forum Discussion
Excel adds '@' AND single quotes around cell reference in formula
I have this string I want to put into a cell as a formula: =Substitute(Substitute(Substitute(Substitute(F3,"{ ",""),"{",""),"}",""),CHAR(34) & ":" & CHAR(34),":") If I use FormulaR1C1 I get: =SUBS...
F3 is not an R1C1 reference. Either use R3C6, or change Formula2R1C1 to Formula2.
