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 …

Hi @Bhargavi_Lokapur , Please this new update formula. "=CONCATENATE(D2,\""+" "+"\",\""+"INV NO"+"\",\""+"-"+"\",E2,\""+" "+"\",D3,\""+" "+"\",\""+"INV NO"+"\",\""+"-"+"\",E3,\""+" "+"\",D4,\""+" "+"\",\""+"INV NO"+"\",\""+"-"+"\",E4,\""+" "+"\",D5,\""+" "+"\",\""+"INV NO"+"\",\""+"-"+"\",E5)" Th…

How to write the concatenate formula in write cell in uipath

Help Studio

nikhil.girish (Nikhil Girish ) February 24, 2022, 11:20am 2

Hi @Bhargavi_Lokapur

please find below link for your reference

Thanks

Topic		Replies	Views
How to concatenate the value in uipath Automation Ops question , automation_ops	12	374	April 29, 2024
Excel - Write cell formula error Studio excel , studio , question , activities_panel , writecell	10	2167	November 5, 2022
Concatenate excel formula Studio studio , question , activities_panel	3	1067	November 7, 2021
Error writing excel formula with " " Studio studio , question , outline_panel	19	1035	July 14, 2023
How to paste the actual formula into a cell Automation Ops question , automation_ops	14	630	February 2, 2024

How to write the concatenate formula in write cell in uipath

Related topics