Formulas‎ > ‎Formulas‎ > ‎

Extract % from the Securities or any Text

posted Jan 29, 2011, 10:18 PM by Ayush Jain   [ updated Jan 29, 2011, 11:00 PM ]

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.

Comments