| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function with Another Function
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with Another Function
=IF(ISNUMBER(Find("Fund",A1)),NumberOnly(A1),"")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with Another Function
This seems to work:
=MID(A1,FIND("Fund:",A1&"Fund:"),999) Test it and see for yourself. Regards, Ryan--- -- RyGuy "Alex" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with Another Function
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 "ryguy7272" wrote in message ... This seems to work: =MID(A1,FIND("Fund:",A1&"Fund:"),999) Test it and see for yourself. Regards, Ryan--- -- RyGuy "Alex" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
