title: In Excel how to get the left 5 characters of each cell in a specified column and put them into a new column
body: <p>I want to take the left 5 characters of each cell in column E and put them into the adjoining cell in column F:</p>
  
  <pre><code>A...B....C...D......E..................F
  123.bb...cc..dd.....90210ABCE13........90210
  555.bb...cc..dd.....10056Z19s..........10056
  </code></pre>
  
  <p>Using Left(x, 5) function, how does Excel say "do this to every cell in the specified column"?</p>