title: Pull from List Excel
body: <p>I have a set list that is frequently changed. Example shown below:</p>
  
  <pre><code>A1 AEZS
  A2 AEMD
  A3 EARS
  A4 BCT
  A5 BSTG
  A6 CHFS
  A7 BPMX
  A8 ABCD
  A9 ZERNA
  A10 APPL
  </code></pre>
  
  <p>I want to extract from this list to pull the words that start with the letter "A", and make it into another list. From my research, I'm aware that using the following function. </p>
  
  <p>Below is the end result I would like to do (C column is arbitrary):</p>
  
  <pre><code>C1 AEZS
  C2 AEMD
  C3 ABCD
  C4 APPL
  </code></pre>
  
  <p>How can I do this? 
  I'm aware that using the formula <code>=IF(LEFT("A",1)....etc</code> is probably a good start. But I am new to Excel, and I am not too familiar to working with it. Additionally, I would like to be able to keep the cells in their each row (as in not all into one cell)</p>