Excel - Concatenate - Formula Error as end of expression expected


I have been reviewing the forum for a while and I cannot seem to figure out why UI Path says end of expression expected…

=CONCATENATE(“E”&TEXT(G2,“mmddyy”)&“-”&TEXT(H2,“mmddyy”)&" “&Q2&” “&“P”&F2&” "&P2)

I am trying to use this formula in a write cell activity.

Any ideas would be greatly appreciated.

You need to escape your quotes. Try this:

“=CONCATENATE(”“E”“&TEXT(G2,”“mmddyy”“)&”“-‘’&TEXT(H2,”“mmddyy’')&”" “”&Q2&“” “”&““P””&F2&“” “”&P2)"

1 Like


Thank you for the reply, this worked great!

Such a simple fix.

1 Like

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