How to Concat formula in "write cell" activity?

[Prabin_Chand]

Hello everyone!
I need to join dynamic alphabets while using excel formula using “write cell” activity.
for example : =RIGHT(Z2,6) , This is my formula and “Z” will be dynamic in process . I have attached picture or my code. but it’s output is different for which I’m getting error

\

ERROR is here

[arivu96 (Arivazhagan A)]

Try below ode

"=RIGHT("+iBankRfNo.ToString()+"2,6)"

Regards,
Arivu

[Prabin_Chand]

activity is not accepting + operator . To concatenate & is is only accepted

[Prabin_Chand]

not worked!

[Divyanshu_Divyanshu]

None of them is working?

[Prabin_Chand]

yes none of this is working

[Divyanshu_Divyanshu]

if you can share the xaml, it will be great

[Prabin_Chand]

I found the solution for it.

Trim(“=RIGHT(”+iBankRfNo.ToString()+“2,6)”).ToString.Replace(Environment.newLine, “”)