title: Read in Excel column with numbers and characters to R
body: <p>I'm trying to read in an excel file to R using <code>read_excel</code>(it's a <code>xlsx</code> file), I have columns that contain letters and numbers, for example things like <code>P765876</code>. These columns also have cells with just numbers i.e <code>234654</code>, so when it reads in to <code>R</code> it reads as an Unknown (not character or numeric) but this means that it gives any cell which has a letter and number a value of <code>NA</code>, how can I read this in correctly?</p>
  
  <p>My code at the moment is </p>
  
  <pre><code>tenant&lt;-read_excel("C:/Users/MPritchard/Repairs Projects/May 2017/Tenant Info/R data 1.xlsx")
  </code></pre>