How to write the concatenate formula in write cell in uipath

hello sir… i have one concatenate formula… when i write this formula in write cell it give error.
Formula is =CONCATENATE(D2," “,“INV NO”,”-",E2," “,D3,” “,“INV NO”,”-",E3," “,D4,” “,“INV NO”,”-",E4," “,D5,” “,“INV NO”,”-",E5)
error is ; is expected. name INV could not be found. operator '- ’ can not be applied to operands of type “string”

Hi @Bhargavi_Lokapur

please find below link for your reference

Thanks

sir… my concatenate formula is different. so when i put this formula in write cell I have getting error…

Hi!

Could you please mention your expected output?

Regards,
NaNi

RAHI SPICES INV NO-RS-29/21-22 DYNAMIC AGRO INTERNATIONAL INV NO-DAI-079/08/21-22 DYNAMIC AGRO INTERNATIONAL INV NO-DAI-084/08/21-22 EXOTICA INTERNATIONALS INV NO-EI/21-22/78
this is my expectation op
formula is =CONCATENATE(D2," “,“INV NO”,”-",E2," “,D3,” “,“INV NO”,”-",E3," “,D4,” “,“INV NO”,”-",E4," “,D5,” “,“INV NO”,”-",E5)

Is it working well in excel? when we type this formula manually?

If yes could you please show me the snap.

Regards,
NaNi

Hi @Bhargavi_Lokapur ,

Try this CONCATENATE(D2,"" “,“INV NO”,”-"",E2,"" “,D3,” “,“INV NO”,”-"",E3,"" “,D4,” “,“INV NO”,”-"",E4,"" “,D5,” “,“INV NO”,”-"",E5).

As excel also except the string which is in the double quote so to pass double quote through UiPath we have to replace " with “”.

If these works mark it as a solution.

Happy Learning,
Achal Sharma

; expected this error is getting in write cell

yes it is working in excel .

Try this update formula

“=CONCATENATE(D2,”" “”,"“INV NO”",""-"",E2,"" “”,D3,"" “”,"“INV NO”",""-"",E3,"" “”,D4,"" “”,"“INV NO”",""-"",E4,"" “”,D5,"" “”,"“INV NO”",""-"",E5)"

i copied your updated formula and try in my excel. but I GOT error. like
; expected. the
unexpected character ‘"’
invalid expression terms
the name “D2” does not exist in the current context.

can you show me you code where you are applying this formula?

Try this formula. It is working on my side.

but here in my it gives same error

the formula which you write in write cell …the same formula u gave me ? right

yes it is same

but it gives error here

same error