View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default Embedding IF: depends on result..


for those who wanted to know, Answer found to work:

060705 Extract number from text/number string..
Answer, for input below:
=IF(CC9="","",IF(LEFT(CC9,3)<"<i",
--MID(LEFT(CC9,LEN(CC9)-4),SEARCH("<b",CC9)+3,255),
--MID(LEFT(CC9,LEN(CC9)-8),SEARCH("<b<i",CC9)+6,255)))

<i11:19am</i - <b<i0.16</i</b


=MID(LEFT(A1,LEN(A1)-4),SEARCH("<b",A1)+3,255) Short Answer: Dave
Peterson

input variations a
<i11:19am</i - <b<i0.16</i</b
11:35am - <b0.5601</b
11:35am - <b10.56</b
11:35am - <b1111.5601</b