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 <karan1...@gmail.com> wrote:
> 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
>
> <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
> <https://plus.google.com/111143524614789164919/posts>
> <http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann>
> <http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>
>
>
>
>
> 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
>>
>> <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
>> <https://plus.google.com/111143524614789164919/posts>
>> <http://www.myspace.com/singhkaran>
>> <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/>
>> <http://karanxel.wordpress.com/>
>>
>>
>>
>
> --
> ----------------------------------------------------------------------------------
> 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
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
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
Extract specific string by DILIPandey.xls
Description: MS-Excel spreadsheet
