Here is the solution.
--- On Sun, 8/26/12, Kuldeep Singh naukrikuld...@gmail.com wrote:
From: Kuldeep Singh naukrikuld...@gmail.com
Subject: $$Excel-Macros$$ Only MID Function
To: excel-macros@googlegroups.com
Date: Sunday, August 26, 2012, 1:07 PM
Hi Experts,
Extract 10 from
: Kuldeep Singh naukrikuld...@gmail.com
Subject: $$Excel-Macros$$ Only MID Function
To: excel-macros@googlegroups.com
Date: Sunday, August 26, 2012, 1:07 PM
Hi Experts,
Extract 10 from the reference numbers by using MID Function, if 10 is
not in middle then it will show 0
Request you
=IF(MID(A2,4,2)=10,0,10 is not in middle)
On Tue, Aug 28, 2012 at 11:54 AM, ravinder negi ravi_colw...@yahoo.comwrote:
Here is the solution.
--- On *Sun, 8/26/12, Kuldeep Singh naukrikuld...@gmail.com* wrote:
From: Kuldeep Singh naukrikuld...@gmail.com
Subject: $$Excel-Macros$$ Only MID
Dear Kuldeep,
Plz confirm that whether Data in column-A is Date or text. If it's Date
then use bellow mentioned formula to exact 10, and if it's text then you
should first change column A data in text formate to use MID formula to
exact your desired text.
=IF(MONTH(A2)=10,10,0)
On Sun, Aug 26,
Hi Experts,
Extract 10 from the reference numbers by using MID Function, if 10 is
not in middle then it will show 0
Request you to, please MID function short easy.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the
This formula is not working. please check the same.
=IF(IF(LEN(H6)/IF(ISERROR(FIND(10,H6)),1,FIND(10,H6))=2,1,0)=1,MID(H6,IF(ISERROR(FIND(10,H6)),1,FIND(10,H6)),2),0)
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the