Concantenate formula

Help Studio
, ,
1

I want to write this formula in write cell but it gives error.
=CONCATENATE(A1,": “,A2,B1,”: “,B2,C1,”: “,C2,D1,”: “,D2,E1,”: ", E2)

I put all this in “” but still it give error : } expected.

2

Hi,

Can you try the following expression?

VB

"=CONCATENATE(A1,"": "",A2,B1,"": "",B2,C1,"": "",C2,D1,"": "",D2,E1,"": "", E2)"

C#

"=CONCATENATE(A1,\": \",A2,B1,\": \",B2,C1,\": \",C2,D1,\": \",D2,E1,\": \", E2)"

Regards,

3

Thanks a Lot . Its works good.

1 Like
4

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