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