Hello,

Could someone help to identify the issue with the below please? It says there is a syntax error. I'm sure it's something simple like an issue with the quotes but I can't seem to get it to work.

.Formula = "="""&LEFT($A2,6)&""&RIGHT($A2,6)&"",""&$B2&"",""&$C2&"",""&$D2&"",""&$E2&"",""&$F2&"",""&$G2&"",""&$H2&"",""&TEXT($J2,""yyyy/mm/dd"")&""""
I am trying to get it to appear like this:

"xxxxxx-xxxxxx","text","text","text","2020/08/17"

Thanks!