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”
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?
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