“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

hello..i need help in left right and mid function

Solved by A. H. in 16 mins

=IF(X3= "MCS",IF(DATE(LEFT(V3,4), MID(Y3,5,2), RIGHT(Y3,2),"MCS "&" "&TEXT(DATE(LEFT(Y3,4), MID(Y3,5,2), RIGHT(Y3,2)),"mm/dd"),IF(V3=0,"Complete"),IF(OR(Z3="UN1 ",R31="PCE "),"Pharmachoice To Purchase"),IF(Q5=130,"Pending Transfer From 120",))))

Solved by A. C. in 26 mins

Need to parse the data without using excel commands and by only using formula (=MID, =LEFT, =RIGHT, =LEN). I only have the classification and semester columns left, but I'm struggling to write the right formula to do so.

Solved by M. Q. in 17 mins

Can you re edit this formula for me =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))

Solved by S. L. in 24 mins

Hi I need a help with this formula- =IF(COUNTIF(I48,{"*hrs/OT*"}),MID(I48,7,5)-LEFT(I48,5)+(MID(I48,7,5)<LEFT(I48,5))*24,IF(COUNTIF(I48,{"*WO/OT*"}),"09:00:00",IF(COUNTIF(I48,{"*OT*"}),MID(I48,7,5)-LEFT(I48,5)+(MID(I48,7,5)<LEFT(I48,5))*24)-"09:00:00")) The above will refer to a cell that contains - 20:00-02:00-6hrs/OT for example and returning result will be 06:00:00 However, if the cell has none of the above conditions in { } then it gives ##########. I want either 0 or nothing. Kindly help.

Solved by O. H. in 19 mins