jassybun
Member
I have this formula and now that I am changing from PROPER(RIGHT(X25,LEN(X25)-10)) part to just PROPER(X25), it doesn't work
old formula that works:
=IFERROR(CHAR(149)&" "&IF(J25<>$J$13,TEXT(J25,"m/d/yy")&" ","")&PROPER(RIGHT(X25,LEN(X25)-10))&" - "&O25&" - "&PROPER(N25), "")
new formula that doesn't work:
=IFERROR(CHAR(149)&" "&IF(J25<>$J$13,TEXT(J25,"m/d/yy")&" ","")&PROPER(X25)&" - "&O25&" - "&PROPER(N25), "")
old formula that works:
=IFERROR(CHAR(149)&" "&IF(J25<>$J$13,TEXT(J25,"m/d/yy")&" ","")&PROPER(RIGHT(X25,LEN(X25)-10))&" - "&O25&" - "&PROPER(N25), "")
new formula that doesn't work:
=IFERROR(CHAR(149)&" "&IF(J25<>$J$13,TEXT(J25,"m/d/yy")&" ","")&PROPER(X25)&" - "&O25&" - "&PROPER(N25), "")