jump to navigation

Converting Wikipedia Table Data to Numbers September 29, 2008

Posted by ficial in brain dump, techy.
trackback

Wen you copy table data out of wikipedia and paste it into Excel you get messing looking things like

&0000000000230000.000000230,000[2]
&0000000000013575.00000013,575[4]
&-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1.000000

To convert those to usable numbers (or blanks, where appropriate) here’s an Excel formula you can use:

=IF(ISERR(FIND(“-”,C2)),IF(C2=”",”",VALUE(MID(C2,2,FIND(“.”,C2)-2))),”")

Comments»

No comments yet — be the first.