Write Cell Formula Error

Hey friends, I hope we are well. I needed some help on writing excel formulas in the write cell activity- kindly assist with these if you can.




Kindly help,
Many thanks

Emmanuel O.

you should write two " instead of one in formula string
for example: “=SUBSTITUTE(SUBSTITUTE(K3,”“USh”“,”“”“),”“,”“,”“”“)”

1 Like

HI @odure

Can you check with this one



1 Like

Awesome,many thanks,this one worked

This also worked Sir,my sincere appreciation,many thanks.


Friends I keep getting this error in the excel report itself…

Write this formula manually in the excel and check whether it is throwing same error @odure

Yes its bringing the same error when manually entered.

When I enter this =LEFT(C3,SEARCH(" ",C3)-1) - it works in Excel but in Studio,this formula throws an error.

Try this @odure

“=LEFT(C3,SEARCH(”" “”,C3)-1)"


1 Like

This has worked thank you.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.