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. |
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 |