Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert number into words | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |