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#

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,

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

1 Like

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