Write cell with formula containing special symbols

Help
1

Hey Guys,
I need to paste in write cell formula: =(N"“&B1&”",…)
But when I surround it with " " it doesn’t pass.
Any Ideas?
Thanks

1 Like
2

Just replace quotes (“) with two quotes (”") and try @Slavich

1 Like
3

Hi
The term should be like this in write cell activity
“=(N”””&B1&”””,…)“

Hope this would help you
Cheers @Slavich

4

@HareeshMR @Palaniyappan,
It is also doesn’t work like.
The matter is that quotations should be inserted to excel cell too. (So excel cell must be like “=(N”””&B1&”””,…)“.
When I do double quotations in activity, like this " “=(N”””&B1&”””,…)“ " - it doesn’t pass

1 Like
5

Fine may i know wht is to written in excel cell,
leave aside the uipath , kindly tell me what is the formula to be written in the excel cell
based on that lets try to frame in uipath with write cell activity
Cheers @Slavich

6

@Palaniyappan , this is it
=“(N’”&B1&“’ ,”&C1&" ,“&D1&” ,‘“&E1&”’,N’“&F1&”’ , “&G1&” ,“&H1&”,“&I1&”,“&J1+1&”,“&K1&” ),"

7

oh my god
did this formula work in manual
Cheers @Slavich

8

@Palaniyappan,
Yes, its the SQL formula

9

Thats fine
the reason is asked is did that work on executing manually, like pasting this formula did that return us any value
Cheers @Slavich

10

Yes, @Palaniyappan when I paste it manually it works.

11

Great
then here you go
“=”“”(N’“”“&B1&”“”’ ,“”“&C1&”“” ,“”“&D1&”“” ,’“”“&E1&”“”’,N’“”“&F1&”“”’ , “”“&G1&”“” ,“”“&H1&”“”,“”“&I1&”“”,“”“&J1+1&”“”,“”“&K1&”“” ),“”" "

hope this would work
Cheers @Slavich

12

@Palaniyappan, sorry, but again receive still have a compiler error.

13

will that comma comes at the end Cheers @Slavich

14

@Palaniyappan,
Not working. I’m sorry

15

@Palaniyappan, maybe u have more suggestions?
Thank you

1 Like
16

@Slavich,

Can you give a last try without the quotes in entire formula?

18

@HareeshMR
doesnt pass

19

It’s working for me @Slavich

image
image741×394 9.53 KB

20

@HareeshMR,
It seems you took not the original one. The original is:
=“(N’”&B1&“’ ,”&C1&" ,“&D1&” ,’“&E1&”’,N’“&F1&”’ , “&G1&” ,“&H1&”,“&I1&”,“&J1+1&”,“&K1&” ),"
try with this one please.

21

testExcelFormula.xaml (5.4 KB)