Automation writing #Name? instead of value

[Mathkar_kunal]

Hello,
i am writing simply = or < 40 using write cell in excel

but when i am checking excel it is writing like name? like below

what is the issue?
i

[Dinesh_Guptil]

Hi @Mathkar_kunal

You Can Assign in For Each loop

currentrow(“TestKey”).tostring=“= or <40”

It Helps

[argin.lerit]

@Mathkar_kunal = or < 40 is not a valid Excel formula hence it comes back as #NAME?. Manually type in Excel first the formula you want and once that is working, copy that to the Write Cell activity.

Hope this helps!

[B_H_Akshatha_Pai]

Try this way

Regards,

[devasyasingh]

@Mathkar_kunal Use Apostrophe mark (‘) just before your string inside double quotes. You will get your desired output. While reading the value Apostrophe mark (’) will be ignored. Refer images.