title: Matlab xlsread function
body: <p>I have 'data.xlsx' file with cells of numbers and letters.</p>
  
  <p>when I run this command:</p>
  
  <pre><code> [num,txt,raw] = xlsread('data.xlsx');
  </code></pre>
  
  <p>I got:</p>
  
  <pre><code>num =
  
  NaN   NaN   NaN  
  NaN   NaN     6  
  NaN   NaN   NaN  
    4   NaN   NaN  
  
  txt = 
  
  'a'    'd'    'g'
  'b'    'e'    '' 
  'c'    'f'    'h'
  ''     ''      ''
  </code></pre>
  
  <p>there is a way to get a new variable which will contain both? something like:</p>
  
  <p>raw =</p>
  
  <pre><code>'a'    'd'    'g'
  'b'    'e'    '6' 
  'c'    'f'    'h'
  '4'     ''      ''
  </code></pre>
  
  <p>maybe by using num2str?</p>
  
  <p><strong>I solved my problem, thanks all</strong></p>
  
  <p>in yuk's solution, I got:
  <img src="https://i.stack.imgur.com/jqUlu.png" alt="enter image description here"></p>
  
  <p>p.s. my version is Matlab 2010a.</p>