Hi Karan,
Try dis one TRIM(MID(E13,FIND("Teacher",E13,1)-25,20))
Thnks
On Oct 21, 6:12 pm, "dguillett1" <dguille...@gmail.com> wrote:
> Sub extractstring()
> On Error Resume Next
> For Each c In Range("i1:i2")
> f1 = InStr(c, ")") + 1
> f2 = InStr(c, "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: 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 Sheelavantar.
> Sri Vijaya Mahantesh Arts` Comm & Science College, llkal Tq: Hungund
> (1964) A/S/C/PG Dipin IndChem PGDCA. Enrol 702, Teachers 34, Principal-Sri R
> M Shivapujimath.
>
> Kaяan
>
> On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 <karan1...@gmail.com> wrote:
>
> Dear All,
>
> Need your help to extract some specific text.
>
> Exam.
> Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/
> BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade.
>
> I need to extract ) A/S/C/BBA. Enrol from highlighted text. Kindly help me
> in this.
>
> Thanks
> Kaяan
>
> --
> ---------------------------------------------------------------------------
> -------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
