PDA

View Full Version : Excel Formula To Extract Values From Text



Howardc
08-22-2012, 05:37 PM
I have the following text below and need a formula to extract values as follows

check deposit fee 0.020% per Month -need to extract 0.020%
mortage security $ 2.25 for every $1.00 borrowed -need to extract the first value i.e $ 2.25

I need a formula that will do the trick

Your assistance in this regard is most appreciated

Excel Fox
08-22-2012, 09:05 PM
Rick's formula from this (http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/) thread

=LOOKUP(9.9E+307,1*LEFT(MID(A1,MIN(FIND({0,1,2,3,4 ,5,6,7,8,9},A1&"0123456789")),999),ROW($1:$999)))