Get instant live expert help on I need help with excel left right mid
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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