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.