Forum Discussion
hoacvxd
Dec 02, 2022Copper Contributor
How to remove @ character in formula in excel
I use C# to create formulas in excel and have encountered a problem: The formula always appears the @ character immediately after the = sign and the result always gives the error #VALUE!.
After creating the formula, I used the Replace function to remove the @ character, but it didn't work.
Please, how to remove the @ character in the formula?
2 Replies
- hoacvxdCopper Contributor
Thank you, after I switched to cells object and applied Formula2 this solved the problem.