Hi dude,
here is the solution.
keep the 1st record on C11 , 2nd on C12 and so on. or keep 1st record on anywer
but change the C11 value in the formula accordingly.
=TRIM(MID(C11,FIND("%",C11,1)-5,4))
Regards,
Hanumant
________________________________
From: "Chidurala, Shrinivas " <shrinivas.chidur...@citi.com>
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Sent: Wed, 19 January, 2011 8:04:38 PM
Subject: $$Excel-Macros$$ Help
Dear All,
Please can any one help me to extract percentage in given securities by way of
VBA code and formula.
Security Percentage
REC 07.60% 22JAN13 07.60
08.80% STATE BKOF BK&JAIPUR 05SEP11 FD
NAT HSG BK 6.90% 30OCT12 (P/C - 30OCT11)
HDFC 0.00% 24AUG12
Thanks in advance.
Regards,
Shrinivas
Citi® Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph - +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.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
--
----------------------------------------------------------------------------------
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
