Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
060705 Extract number from text/number string..
is there a way to make the following work? thanks =IF(CC9="","",--MID(LEFT(CC9,LEN(CC9)-8),SEARCH("<b<i",CC9)+3,255)) to extract: 0.16 from: (formula above gets #Value error) <i11:19am</i - <b<i0.16</i</b ---------- other variation, have formula that works for different input: =IF(CC9="","",--MID(LEFT(CC9,LEN(CC9)-4),SEARCH("<b",CC9)+3,255)) 11:35am - <b0.5601</b |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
Calculating number of letters in a string ... | Excel Discussion (Misc queries) | |||
Calculating number of letters in a string ... | Excel Worksheet Functions |