Re: $$Excel-Macros$$ Query on Extract word

(CONCATENATE("MOC ",MID(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," > ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," > ","")))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A

RE: $$Excel-Macros$$ Query on Extract word

"")," ",""),(FIND("MOC",UPPER(SUBSTITUTE(SUBSTITUTE(A1351,"-","")," ","")))+3),2),1))<58)),"0","-1"),"No MOC") PFA Regards Pankaj Sharma (PJ) From: excel-macros@goog

Re: $$Excel-Macros$$ Query on Extract word

This will work =IFERROR(IFERROR(MID(A2,FIND("MOC",A2,8),7),UPPER(MID(A2,FIND("moc",A2,7),8))),UPPER(MID(A2,FIND("Moc",A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command. Prashant On Wed, May 20,

$$Excel-Macros$$ Query on Extract word

Dear Experts, Please help. Query is in the attached sheet. -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.faceboo