In finance & banking transactions, The interest rate is used in the name of many securities & transactions...If you have this data in excel sheet , then you can filter out the interest rate in separate column using excel formulas . HERE IS HOW

You will have to use MID & FIND function to extract the % and TRIM function to remove the spaces.

Security	Interest Rate	Formula Used
ABB 07.60% 22JAN13	07.60	=TRIM(MID(A2,FIND("%",A2,1)-5,5))
08.80% STATE BKOF BK&JAI 05SEP11 FD	08.80	=TRIM(MID(A3,FIND("%",A3,1)-5,5))
NAT HSG BK 6.90% 30OCT12	6.90	=TRIM(MID(A4,FIND("%",A4,1)-5,5))
ICICI 0.00% 24AUG12	0.00	=TRIM(MID(A5,FIND("%",A5,1)-5,5))

Can you extract the date from these securities ?

If yes, please post in the comments.