If function with Another Function

[Alex]

I have a function that extracts the number only from a string. Example: Cell
A1: Fund: fhks99al, Cell B1 with function =NumberOnly(A1) will result in 99.
Now I have a list in column A where some of the values do not have "Fund:" I
only want to be able to extract the ones that have Fund: and the others can
be blank with no values. This seems to be an If function but can't seem to
accomplish it.

 

[Bob Phillips]

=IF(ISNUMBER(Find("Fund",A1)),NumberOnly(A1),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ryguy7272]

This seems to work:
=MID(A1,FIND("Fund:",A1&"Fund:"),999)

Test it and see for yourself.

Regards,
Ryan---

 

[Rick Rothstein \(MVP - VB\)]

My guess from the OP's post is that he would only want to find "Fund:" at
the beginning of the text. While I'm guessing it would be a highly unlikely
occurrence, your formula would return the value even if an entry has "Fund:"
occurring in the second or later position (for example, "abcFund:fhks99al").

Rick