title: Excel: How to extract a substring by only knowing the strings location?
body: <p>So basically, I am trying to attempt what the title says.</p>
  
  <p>This may be easier to explain with an example:</p>
  
  <p>I have a large string, such as - <code>spreadsheet</code></p>
  
  <pre><code>              A              B         C
        ______________________________________
     1 |  spreadsheet     |  Number |  Letter
     2 |                  |    1    |    s
     3 |                  |    2    |    p
     4 |                  |    3    |    r
     5 |                  |    4    |    e
     6 |                  |    5    |    a
     7 |                  |    6    |    d
     8 |                  |    7    |    s
     9 |                  |    8    |    h
     10|                  |    9    |    e
     11|                  |    10   |    e
     12|                  |    11   |    t
  </code></pre>
  
  <p>Since the string <code>spreadsheet</code> has 11 characters, the numbers from 1 to 11 are created going down in a column. Each string that the number represents is then placed in the column next to it.</p>
  
  <p>I searched for a function everywhere. Only found <code>MID</code> and <code>FIND</code>. Although both those functions require the knowledge of what string you are searching for exactly.</p>
  
  <p>Does anyone have any idea on how to accomplish this?</p>