Hi Karan,
You can use below formula to achieve the desired results. Sample
sheet is also attached with this email for your quick reference.
=MID(A1,SEARCH(")",A1),(SEARCH("Enrol",A1)+4-SEARCH(")",A1))+1)
Regards,
DILIPandey
On 10/21/11, karan 1237 wrote:
> I'v around 8,000 cell like this. I'
;Enrol")
> c.offset(,1)=Mid(c, f1, f2 - f1)
> Next
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: karan 1237
> Sent: Friday, October 21, 2011 3:33 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re: Kind
2011 3:33 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Kindly Help
I'v around 8,000 cell like this. I'v to extract those too.
Ex : Columns
Sri Veerapulakeshi Arts` Science & Commerce College, Badami (1982) A/S/
C. Enrol 553, Teachers 36, Principal-Shri G B Sh
