Re: $$Excel-Macros$$ Re: Extract Text that begins with L

2016-08-08 Thread sourav devrani
Please see the attached file. Regards Sourav Devrani On Tue, Jul 19, 2016 at 11:43 PM, सचिन शर्मा wrote: > Please check > > Cash paid to L986529 - RAMESH KUMAR K > EMP ID > L986529 > > >- =MID(B2,FIND("L",B2),7) > > >- > *" 7 " = Lenth of EMP ID * > > > > On Wednesday, July 20, 2016

$$Excel-Macros$$ Re: Extract Text that begins with L

2016-07-19 Thread सचिन शर्मा
Please check Cash paid to L986529 - RAMESH KUMAR K EMP ID L986529 - =MID(B2,FIND("L",B2),7) - *" 7 " = Lenth of EMP ID * On Wednesday, July 20, 2016 at 10:48:09 AM UTC+5:30, Sundarvelan wrote: > > Dear Experts, > > Please help me to extract EMP ID. > > I have the below sente