title: Excel - All unique words in a range
body: <p>Perhaps I'm trying to do too much, but I have a column filled with text. Each cell has an arbitrary number of words, so for example:</p>
  
  <pre><code>     |         A          |
  =====|====================|
    1  | apple pear yes cat |
    2  | apple cat dog      |
    3  | pear orange        |
  </code></pre>
  
  <p>What I need to do is create a column which is a list of all unique words in that range. So for the above example, the result should be:</p>
  
  <pre><code>     |         A          |   B    |
  =====|====================|========|
    1  | apple pear yes cat | apple  |
    2  | apple cat dog      | pear   |
    3  | pear orange        | yes    |
    4  |                    | cat    |
    5  |                    | dog    |
    6  |                    | orange |
  </code></pre>
  
  <p>In no particular order. Is there any way to do this?</p>