title: If cell contains certain text put this text in a cell
body: <p>I have a dataset like this:</p>
  
  <pre><code>      A     B          C
  1     A     A is this   
  2     B     Z is this
  3     C     D is this
  4     D     A is this
  5     E     K is this
  </code></pre>
  
  <p>If cell B1 contains A, B, C, D or E (so a value of column A) than I want to put A,B,C,D,or E in cell C1</p>
  
  <p>I've tried to do this with the following formula for C1:</p>
  
  <pre><code>=IF(FIND("A";B1;1);"A";IF(FIND("B";B1;1");"B";IF(FIND("C";B1;1) ...
  </code></pre>
  
  <p>But since my column A contains 24 possible values it becomes a very long formula.</p>
  
  <p>Can someone help me to simplify this? </p>