:* Wednesday, May 20, 2015 10:38 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$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
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, 2015
: Wednesday, May 20, 2015 10:38 AM
To: excel-macros@googlegroups.com
Subject: $$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
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 @