Crackone
14th July 2009, 09:07 PM
Got this of mrexcel, its a formula to grab the weight of the horse and change the fraction to decimal, thought someone might use it. The form was from racing and sports.
<table style="font-family: Calibri,Arial; font-size: 9pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 509px;"><col style="width: 56px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="font-family: Arial; font-size: 10pt;">LATEST MODEL Kerry Baumann(Townsville) 16 57 kg </td><td style="text-align: right;">57</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Arial; font-size: 10pt;">RANMOORO (blks) Bob Purcell(Townsville) 17 57 kg</td><td style="text-align: right;">57</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="font-family: Arial; font-size: 10pt;">SUCCESSFUL JO Janel Ryan(Atherton) 4 56½ kg </td><td style="text-align: right;">56.5</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>C2</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B2,SEARCH(CHAR(160)&"kg",B2)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr><tr><td>C3</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B3,SEARCH(CHAR(160)&"kg",B3)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr><tr><td>C4</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B4,SEARCH(CHAR(160)&"kg",B4)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr></tbody></table></td></tr></tbody></table>
(http://www.excel-jeanie-html.de/index.php?f=1)
<table style="font-family: Calibri,Arial; font-size: 9pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 509px;"><col style="width: 56px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="font-family: Arial; font-size: 10pt;">LATEST MODEL Kerry Baumann(Townsville) 16 57 kg </td><td style="text-align: right;">57</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Arial; font-size: 10pt;">RANMOORO (blks) Bob Purcell(Townsville) 17 57 kg</td><td style="text-align: right;">57</td></tr><tr style="height: 19px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="font-family: Arial; font-size: 10pt;">SUCCESSFUL JO Janel Ryan(Atherton) 4 56½ kg </td><td style="text-align: right;">56.5</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>C2</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B2,SEARCH(CHAR(160)&"kg",B2)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr><tr><td>C3</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B3,SEARCH(CHAR(160)&"kg",B3)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr><tr><td>C4</td><td>=VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B4,SEARCH(CHAR(160)&"kg",B4)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))</td></tr></tbody></table></td></tr></tbody></table>
(http://www.excel-jeanie-html.de/index.php?f=1)