thanks all. I actually figured it was easier to do it as an excel formula and have UiPath write it in the dynamic range. i used:
=IF(LEN(P2) = 3, LEFT(P2,2) & “-0” & RIGHT(P2,LEN(P2)-2),LEFT(P2,2) & “-” & RIGHT(P2,LEN(P2)-2))
thanks all. I actually figured it was easier to do it as an excel formula and have UiPath write it in the dynamic range. i used:
=IF(LEN(P2) = 3, LEFT(P2,2) & “-0” & RIGHT(P2,LEN(P2)-2),LEFT(P2,2) & “-” & RIGHT(P2,LEN(P2)-2))