title: Converting excel output from character to numeric in R
body: <p>I have a problem. Say I have a vector x:</p>
  
  <p><code>x</code>:</p>
  
  <pre><code> [1] "2 416" "143"   "280"   "2 503" "144"   "128"   "55"    "697"   "826"   "9"     "35"    "9 257" "234"   "2 044" NA      "219"  
  [17] NA      NA      "219"   "7 431" "82"    "88"    "186"   "231"   "192"   "456"   "585"   "75"    "142"   NA      NA      NA     
  [33] "72"    "246"   "900"   "143"   "231"   "195"   "282"   "226"   "967"   "247"   "2 252" "694"   "64"    "7 744" "204"   "428"  
  [49] "19"    "94"    "174"   "292"   "94"    "172"   "221"   "123"   "404"   "385"   "324"   "346"   "658"   "53"    "377"   "119"  
  [65] NA      "51"    "391"   "1 072" "387"   "1 742" "518"   "173"   "366"   "67"    "163"   "1 151" "382"   "864"   "184"   "172"  
  [81] NA      "538"   "39"    "2 272" "334"   "464"   "82"    "112" 
  
  class(x) 
  "character" 
  </code></pre>
  
  <p>I imported this vector from Excel</p>
  
  <pre><code>x=read.csv(file="C:/Users/Documents/x.csv",header=TRUE,sep=";",na.strings=c("NA",""),
  dec = ",",stringsAsFactors=FALSE,blank.lines.skip = F)
  </code></pre>
  
  <p>No when I try to convert <code>x</code> to numeric, this happens:</p>
  
  <pre><code>as.numeric(x)
  
   [1]  NA 143 280  NA 144 128  55 697 826   9  35  NA 234  NA  NA 219  NA  NA 219  NA  82  88 186 231 192 456 585  75 142  NA  NA  NA  72
  [34] 246 900 143 231 195 282 226 967 247  NA 694  64  NA 204 428  19  94 174 292  94 172 221 123 404 385 324 346 658  53 377 119  NA  51
  [67] 391  NA 387  NA 518 173 366  67 163  NA 382 864 184 172  NA 538  39  NA 334 464  82 112
  Warning message:
  NAs introduced by coercion 
  </code></pre>
  
  <p>So some numbers, i.e. "2 416" is converted to NA, while I want the number to be converted to 2 416. I want R to interpret <code>"2 416"</code> as a numeric value <code>2416</code>What am I doing wrong? </p>
  
  <p>Best Regards</p>