Concatenate excel formula

Help Studio
, ,
1

Hello I want to concatenate two cells i used excel formula in uipath it gives some expression expected error.
my formula is -=CONCATENATE(A1,": “,TEXT(A2,“DD-MM-YYYY”),B1,”: “,TEXT(B2,“DD-MM-YYYY”),C1,”: “,TEXT(C2,“DD-MM-YYYY;;”),D1,” “,TEXT(D2,“DD-MM-YYYY;;”),E1,” ", TEXT(E2,“DD-MM-YYYY;;”))
give me this formula in VB and C#

2

Hi,

Can you try the following?

VB

"=CONCATENATE(A1,"": "",TEXT(A2,""DD-MM-YYYY""),B1,"": "",TEXT(B2,""DD-MM-YYYY""),C1,"": "",TEXT(C2,""DD-MM-YYYY;;""),D1,"" "",TEXT(D2,""DD-MM-YYYY;;""),E1,"" "", TEXT(E2,""DD-MM-YYYY;;""))"

We need to express a double quote as ""

C#

"=CONCATENATE(A1,\": \",TEXT(A2,\"DD-MM-YYYY\"),B1,\": \",TEXT(B2,\"DD-MM-YYYY\"),C1,\": \",TEXT(C2,\"DD-MM-YYYY;;\"),D1,\" \",TEXT(D2,\"DD-MM-YYYY;;\"),E1,\" \", TEXT(E2,\"DD-MM-YYYY;;\"))"

We need to express a double quote as \"

Regards,

3

Thanks a lot .Its done Mam. thanks for cooperate. have good day and happy diwali…

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.