Re: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

2014-02-11 Thread amar takale
t;> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *amar takale >> *Sent:* Tuesday, February 11, 2014 2:40 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ MID function (Search sente

Re: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

2014-02-11 Thread amar takale
Dear Sir I Replace all B27cell to B3 in formula but wrong answer,How to work it Pls explain me. Regards Amar On Tue, Feb 11, 2014 at 2:19 PM, wrote: > Try below mentioned > > Change cell ref.. > > =LEFT(B27,LEN(B27)-FIND("MT.",B27,1)+3) > > > > > > *From:* excel-macros@googlegroups.com [mailto

RE: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

2014-02-11 Thread mr . excel4u
Try below mentioned Change cell ref.. =LEFT(B27,LEN(B27)-FIND("MT.",B27,1)+3) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Tuesday, February 11, 2014 1:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MID functio