Forum Discussion

PhilSmith1964's avatar
PhilSmith1964
Copper Contributor
Jan 27, 2025

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...
excel
Formulas and Functions
Macros and VBA
Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 28, 2025

I'm not a vba guy by any means, but this worked for me with your formula by using Formula2.

  • PhilSmith1964's avatar
    PhilSmith1964
    Copper Contributor
    Jan 28, 2025

    For me, Formula2 puts single quotes around the F3.

     

    Thanx

Resources