I require UiPath Studio to write a formula in excel for me and for some reason I can’t get it to work. I write the exact same text in both Message box and Excel Write Line, but I am getting different results.
The message box result:
The excel result:
For some reason, there are double quotes showing up in the excel file compared to the message box. I need the message box output.
The main problem stems from me needing to write a formula in uipath that will be written to excel, but the double quotes are confusing me.
The formula needs to be:
=MID(IF(IFERROR(FIND(" Q",F2),0)>1,LEFT(F2,FIND(" Q",F2)-1),IF(IFERROR(FIND(".Q",F2),0)>1,LEFT(F2,FIND(".Q",F2)-1),IF(IFERROR(FIND(“Q”,F2),0)>1,LEFT(F2,FIND(“Q”,F2)-1),""))),2,30)
How do I write this as a string exactly as it is?