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 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
--
----------------------------------------------------------------------------------
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
